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

192 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
wombat133986(None) 
combat12316751combat
wombats1435891wombats
bombast1348222bombast
bombax1935752bombax
combats13311682combats
numbat10312082numbat
tombac12258882tombac
tombak14237752tombak
tombal102311022tombal
tomcat101013452tomcat
woman105818002wom_an
womb117022232womb__
wombed14419232wombed
wombs125813342womb_s
womby155910092womb_y
ambit94223713_ambit
bat510988953___bat
boat66360313bo__at
bobcat12411253bobcat
bomb106927423bomb__
bombard1437333bombard
bombasts1444953bombasts
bombe115519313bomb_e
bombed134113873bombed
bomber125014653bomber
bombes124916823bombes
bomblet13412263bomblet
bombs115818823bomb_s
bombyx2232693bombyx
bumboat1349023bumboat
coat67558353co__at
cobalt10317393co_balt
coma87134853com_a_
comae97128423com_ae
comal95125133com_al
comas95833003com_as
comate104124843com_ate
comb106632113comb__
combated1539823combated
combater1439383combater
combe116223543comb_e
combed135516543combed
comber125118503comber
combes125321733combes
combo114519433comb_o
combos125316613combos
combs116122963comb_s
combust1338363combust
comet95946073com_et
comfit133112423comfit
comma114514793comma_
commas124814573commas
commata1338483commata
commit124016703commit
compact153712213compact
compart134016003compart
compas125817063compas
compt116328223com_pt
corban10314693corban
cowpat13312033cowpat
cymbal15236913cymbal
doat56947673do__at
domal85619203dom_al
doubt8720093doub_t
embar94011603_embar
embay123410603_embay
foment113718303foment
forbad122710503forbad
forgat104018583forgat
format113021353format
gamba106018513gamba_
gambas115817513gambas
gambit114714213gambit
gimbal11228813gimbal
goat56250833go__at
goban84414073go_ban
gobbet114214443gobbet
gombo105814043gomb_o
gombos114311093gombos
goombah1543113goombah
goombay1543553goombay
hobbit132810543hobbit
hombre13309303hombre
jumbal1758463jumbal
kombu1347243komb_u
kombus1435523kombus
korat94934433ko_rat
lambast11129893lambast
limba95414983limba_
limbas105313203limbas
limbate1139213limbate
lobar7313013lo_bar
lobate82915243lo_bate
loment84021473loment
loquat1558283loquat
lovat8321043lo_vat
lumbar103610593lumbar
mamba116317523mamba_
mambas125716243mambas
mat58083943__m_at
meat66359603__meat
mimbar1297493mimbar
moat66352033__moat
moment103319683moment
momma85111053momma_
mommas94110653mommas
noma67529463nom_a_
nomad86016183nom_ad
nomas74726413nom_as
nonfat9512183nonfat
nonmeat9312773nonmeat
nougat74712653nougat
numbats1137673numbats
oat39888263_o__at
oba57531553_o_ba_
obas65730933_o_bas
obit66837083_o_bit
omber95316443_omber
ombre94111803_ombre
omit65337373_om_it
oomiac1037063oomiac
oomiak1235353oomiak
oompah1334253oompah
orbit73622063_orbit
rabat72832223_rabat
robot7325973ro_bot
roman75424823rom_an
rowboat1267983rowboat
rumba93612513rumba_
rumbas102512013rumbas
sabbat10314713sabbat
samba95618773samba_
sambal105215183sambal
sambar103914163sambar
sambas104219263sambas
soba64927923so_ba_
sobas74424253so_bas
soma65635293som_a_
soman75024903som_an
somas76030373som_as
somata8312383som_ata
somber103714003somber
sombre10729473sombre
sorbate9311733sorbate
sorbet83924083sorbet
tambac122210243tambac
tambak14249263tambak
timbal102510753timbal
toman75724053tom_an
tomato8313453tom_ato
tomb89029653tomb__
tomback17227743tomback
tombacs13248443tombacs
tombaks15246863tombaks
tombed113812133tombed
tomboy1358213tomboy
tombs97818733tomb_s
tomcats11127773tomcats
tomtit8413853tomtit
towboat1258303towboat
tymbal13236823tymbal
vomit102622573vom_it
wamble134415753wamble
wambly16388663wambly
wat67378923w___at
what105434073w__hat
wheat114924573w_heat
wimble133211923wimble
woad85523943wo__ad
wobble133212313wobble
wobbly16347093wobbly
womans114613653womans
wombier1436543wombier
wombiest1536893wombiest
women104619253wom_en
womera11137593womera
womeras1287593womeras
womyn13426363wom_yn
wont75842503wo__nt
woolhat1346043woolhat
workbag1742923workbag
workboat1745463workboat
worrit92313313worrit
worset96726583worset
worst86330133wo_rst
wort76654753wo__rt
wost76544363wo__st
wot610467483wo___t
zombi1838993zomb_i
zombie1937323zombie
zombis1936283zombis

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.373479064.3
2DLD Change Limit1127161925.89319127.1
3Display Results1921920.0464173.9
 (SQL Overall)1786911926.31228309.7
 
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.