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

87 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
akimbo144339(None) 
ambo88225132a__mbo
bimbo114811862_bimbo
limbo95614802_limbo
skimo116312532skim_o
abmho1236793a_bmho
abo59045963a___bo
adobo84711593a_dobo
agio57828453agi__o
ahimsa1134783ahimsa
aikido1135473aikido
aim57858213a_im__
aimed85626053a_imed
aimer75926823a_imer
aims67738183a_im_s
akin86328033aki__n
alamo7418143alam_o
alibi7514223ali_bi
ambos95321243a__mbos
amido85720963ami_do
amigo86515453ami_go
amino75425493ami_no
ammino1069873ammino
ammo85520133a__mmo
anima74620073anim_a
animal85016253animal
animas84418723animas
animato91610623animato
anime75423203anim_e
animes84719593animes
animi74016663anim_i
animis84615943animis
animus84211613animus
arioso64312403arioso
aristo6414033aristo
ausubo853653ausubo
aviso85713963avi_so
azido155411543azi_do
bilbo95513603_bilbo
bimbos124610513_bimbos
chimb144813563chimb_
chimbs153910303chimbs
climb115413593climb_
climbs12498723climbs
combo114519433_combo
crambo1238043crambo
daimio937463daimio
daimyo1233193daimyo
dumbo105614063_dumbo
gombo105814043_gombo
gumbo104413583_gumbo
hakim14311823hakim__
hakims1537303hakim_s
jumbo164311073_jumbo
kalimba1542663kalimba
kibbe135211963_kibbe
kibbi13449263_kibbi
kibe106523433_ki_be
kiddo11398943_kiddo
kilo86028663_ki_lo
kimono12105413_kimono
kino86233613_ki_no
kobo107422103_k_obo
kombu1347243_kombu
limb85429373_limb_
limba95414973_limba
limbi96513793_limbi
limbos104712133_limbos
limbs96118933_limbs
limby125714063_limby
limo65529733_lim_o
makimono1641943makimono
mambo115215733_mambo
marimba1354983marimba
mimeo96018683_mimeo
nimbi94910293_nimbi
primo95017913prim_o
sambo95118013_sambo
skibob1433423ski_bob
skidoo1136093skidoo
skim105322493skim__
skimos12548803skimos
skimp135411313skim_p
skimps14488043skimps
skimpy17475723skimpy
skims114517183skim_s
umbo85516653__umbo

Search took 9 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.1401276364.3
2DLD Change Limit112716878.25013662.5
3Display Results87870.0302900.0
 (SQL Overall)178691878.42021222.2
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.