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 “ultimo” 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.

86 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
ultimo84600(None) 
ultima836311ultima
limo65529732_l_imo
ultimas936362ultimas
uptime1067672uptime
alamo7418143al_amo
albino839933albino
alnico877943alnico
altho86312603alt_ho
alto47831263alt__o
betime105914833betime
blimp115612943bl_imp
blimy125212823bl_imy
centimo11609543centimo
claim95616913claim_
claims105211573claims
climb115413593cl_imb
clime95720893cl_ime
culti76317253culti__
cultic105111903culti_c
cultish12139113cultish
cultism11158003cultism
cultisms12126713cultisms
cultist91412713cultist
glim76026353gl_im_
glime85620193gl_ime
glims87417673gl_ims
intima81910033intima
intime81014273intime
latigo73410013latigo
latino64120473latino
lido56028163_l_ido
lilo46731563_l_ilo
lima65734133_l_ima
limb85429383_l_imb
limbo95614813_l_imbo
lime66244933_l_ime
limn66527693_l_imn
limos75320813_l_imos
limp88432493_l_imp
limy95727713_l_imy
lino46343373_l_ino
litho86513783_litho
luting75221753luting
lutist64317553lutist
multimode1445753multimode
multiton1087343multiton
olio46829673ol_i_o
optima10106533optima
optime1079353optime
patio74426353pati_o
primo95017913_primo
ratio55227583rati_o
retime85321803retime
sentimo9449623sentimo
skimo116312543_skimo
slim66631963sl_im_
slime74925753sl_ime
slims75423653sl_ims
slimy105417423sl_imy
stime76521803_stime
stimy105114743_stimy
time66235013__time
tiro46832363__tiro
ulama7711473ul_ama
ulema7109713ul_ema
ultimacy1543663ultimacy
ultimata1055563ultimata
ultimate1049203ultimate
ultra539363ult_ra
ultras6310193ultras
untame82513603untame
untidy1059153untidy
untie54425493unti_e
untied73720813untied
unties64326923unties
until53517743unti_l
untimed102713373untimed
unto45824283unt__o
untrim8310683untrim_
untrims938613untrims
uptempo1342413uptempo
uptick1436763uptick
uptilt8410803uptilt
uptimes1177553uptimes
utile54718933u_tile

Search took 6 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 Filter1786911127160.373479064.3
2DLD Change Limit112716864.73323814.9
3Display Results86860.0332606.1
 (SQL Overall)178691865.13934771.6
 
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.