Welcome!   |  Search Scrabble® Dictionary using DLD   |  Statistics   |  Compare any two Strings using DLD   |  Reference   |  Your IP

Dictionary Search Results using Damerau-Levenshtein distance in T-SQL

Here are the results of your fuzzy-string dictionary search for “servitor” with Change Limit: [1] [2] [3] [4]

You can choose a higher Change Limit to return more words, although it will take longer.
to automatically increase the Change Limit after seconds.

58 similar words found! Changes to Transform each Found Word to your word are shown as:
 remove a letter ~ replace a letter ~ swap two letters ~ _add a letter from your word
(Use the links in the Changes column to see more Transformation details.)

Found WordScrabble ScoreSearched PreviouslyFound PreviouslyChangesTo Transform to your Word
servitor114506(None) 
servitors1245211servitors
heritor10310562her_itor
servicer1335262servicer
survivor1442402survivor
aerator7314843aer_ator
creditor1145903creditor
deviator1248313de_viator
devisor11357043de_visor
editor738663_e_ditor
enervator1245523enervator
erector93513813_erector
evictor12346363_e_victor
excitor1645993_excitor
fervor1235643ferv__or
genitor837273ge_nitor
heritors11310903her_itors
levator10298963le_vator
nervier10298833nervi_er
previsor13116303previsor
revisor10388733re_visor
sartor6313883sar__tor
savior9710173s_avi_or
secretor1045683secretor
sector83415933se__ctor
seisor63712343se__isor
seizor15428533se__izor
selector1048613selector
senator7313073se_nator
senior63214053se_ni_or
sequitur1742973sequitur
serpigo1044833serpigo_
serpigos1143843serpigos
server94917713serv__er
service1239083servi_ce
serviced1435613serviced
servicers1444663servicers
services1338573services
serviette1242963serviette
servile10310643servi_le
serving113014983servi_ng
servings12249223servings
servitude1343083servitude
servo84516683serv__o_
servomotor1551253servomotor
servos93812723serv__os
sorbitol1043743sorbitol
stertor7310093ster__tor
straiter8311783straiter
stridor8467393str_idor
suitor63311053s__uitor
supervisor1543943supervisor
surveyor1442263surveyor
surviver1434683surviver
survivors1542443survivors
territory1245093territory
traitor7310123_traitor
verditer1236223verditer

Search took 8 seconds overall (including website activity, plus SQL activity in the following phases):

  1. Length Filter: Limit the application of DLD to words with length difference of no more than the Change Limit.
  2. DLD Change Limit: Apply DLD to each remaining word, limiting each comparison according to the Change Limit.
  3. Display Results: Return the results, with similar words marked up to highlight differences.
SeqSearch PhaseWords CheckedWords MatchedSecondsWords Per Sec
1Length Filter1786911461620.406440125.6
2DLD Change Limit146162586.68621860.9
3Display Results58580.0331757.6
 (SQL Overall)178691587.12525079.4
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2025  |  Published At: SQLServerCentral (with Source Code)  |  Presented At: SQLSaturday #144  |  Demonstrated For: Sacramento SQL Server User Group  |  Developed For: Repo Remarketing  |  Running On: Microsoft SQL 2014 RTM Standard on Server 2012 R2 (also successfully run on SQL 2012 Web Edition, SQL Express 2008-2008R2, and SQL Server 2000-2005 Standard)  |  SQL Performance Monitoring By: Confio Ignite  |  American Scrabble® Dictionary From: Internet Scrabble Club  |  Scrabble® is a registered trademark. All intellectual property rights in and to the game are owned in the U.S.A and Canada by Hasbro Inc., and throughout the rest of the world by J.W. Spear & Sons Limited of Maidenhead, Berkshire, England, a subsidiary of Mattel Inc. Mattel and Spear are not affiliated with Hasbro. This site is not affiliated with Scrabble®, Mattel, Spear, or Hasbro in any way. This site is for entertainment and technical education purposes only.