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 “amoeba” with Change Limit: [1] [2] [3]

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

123 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
amoeba103560(None) 
ameba9312381am_eba
amoebae1145531amoebae
amoeban1144911amoeban
amoebas1135961amoebas
amebae1049632am_ebae
ameban1039092am_eban
amebas10311452am_ebas
amoebean1242342amoebean
amoebic1346152amoebic
aba512850953a___ba
abba810522653a__bba
abolla8410193abolla
aboma91114603abo_ma
aceta74017353a_ceta
adnexa1433673adnexa
adobe84814713ado_be
adobes94411533adobes
adobo84711593ado_bo
agora6914333ago_ra
akela9311343a_kela
alba68328333a__lba
algebra1043043algebra
alodia71112453alodia
aloe45540193aloe__
aloes54933673aloe_s
aloha8513613alo_ha
ama510853303am___a
amarna839793amarna
ambeer104511603ambeer
amber94523213ambe_r
ambers104519583ambers
ambery133811133ambery
ambo88225143am__bo
amboina1137963amboina
amboyna1443683amboyna
amebean1144853am_ebean
amebic1239113am_ebic
ameer75618983am_eer
ameers84015573ameers
amen66733153am_e_n
amend85717753am_end
amens75624843am_ens
ament76036543am_ent
amia66836903am__ia
amie66339853amie__
amies76837693amie_s
amiga85514813am_iga
ammonia1148693ammonia
amnesia938293amnesia
amnia75918643am_nia
amoebaean1351283amoebaean
amoeboid1344113amoeboid
amok10217403amo__k
amoks11413553amo_ks
amole75724593amo_le
amoles84122193amoles
among85813303amo_ng
amoral8314633amoral
amort75832203amo_rt
amount8414483amount
amour75014853amo_ur
amours83512663amours
amped104820513ampe_d
ampere10514413ampere
amreeta945163amreeta
amrita8411133amrita
amusia839173amusia
anoa45634473ano__a
anopia83412393anopia
anoxia133510023anoxia
aorta55922573a_orta
apnea73413413apne_a
apnoea867093apnoe_a
aporia8315863aporia
ardeb8314523ardeb_
ardebs937013ardebs
area45843393a_re_a
areca75618633a_reca
arena55323813a_rena
areola6813673areola
arepa75615563a_repa
aroma71220143aro_ma
arriba867683arriba
arroba898663arroba
asea46327183a_se_a
atonia63816513atonia
aucuba1045493aucuba
cabomba1544083cabomba
camera10313693cam_era
camorra11115763camorra
dagoba1074943dago_ba
endamoeba1452033endamoeba
entamoeba1362233entamoeba
gamba106018513gam__ba
gleba83910243_gleba
mamba116317523_mamba
mega77620873_m_ega
mesa67025483_m_esa
meta65932413_m_eta
moa57249183_mo__a
mob78651923_mo_b_
mobs85737373_mo_bs
mocha1249923_mocha
moira71012023_moira
mola66035633_mo_la
momma85111053_momma
moola75117033_moola
mora66641273_mo_ra
moxa136917743_mo_xa
myxamoeba2551273myxamoeba
oba57531553__o_ba
omega836383om_ega
phoebe1335003phoebe
ramona8412413ramo_na
samba95618773sam__ba
samosa8510203samo_sa
soba64927923_so_ba
toea46732333_toe_a
womera11137593womera
zareba1736423zareba
zareeba1842423zareeba
zoea137118423_zoe_a

Search took 7 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.393454684.5
2DLD Change Limit1127161235.81019400.3
3Display Results1231230.0462673.9
 (SQL Overall)1786911236.24928595.1
 
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.