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

199 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
faultier113528(None) 
vaultier1144291vaultier
baulkier1433532baulkier
faculties1455142faculties
falter94519052fa_lt_er
fattier103513462fa_ttier
faulted11227722fault_ed
faultiest1236092faultiest
faultily1474522faultily
faulting12237732faulting
flauntier1243062flauntier
flutier103011552flu_tier
fruitier1136592fruitier
fustier104213932f_ustier
haulier1059942haul_ier
haulmier1333142haulmier
jauntier1535232jauntier
maltier93015482ma_ltier
saltier74318632sa_ltier
vaulter10257712vault_er
aflutter1163813aflutter
alter54828503_a_lt_er
artier63419733_a_rtier
aulder7511453_aul_der
auntie64317703_auntie_
aunties73920073_aunties
auntlier834903_auntlier
balkier134111983ba_lkier
ballsier1036523ballsier
balmier113811513ba_lmier
battier93515723ba_ttier
bulgier103911213_bulgier
bulkier134111513_bulkier
bullier94116433_bullier
bustier93916153_bustier
cattier93317073ca_ttier
caulker13456893caul_ker
coulter94115603coult_er
courtier1059333courtier
crustier10259533crustier
daintier937403daintier
dallier84215373da_llier
daubier1037103dau_bier
daunter83811753daunt_er
dautie72914703dau_tie_
dauties83315763dau_ties
defaulter1343133default_er
dustier83814133_dustier
earlier72612743earl_ier
fabler116115813fabl__er
faddier1237783fa_ddier
faggier12309843fa_ggier
fagoter1135883fagot_er
fainter103611053faint_er
faller94621233fa_l_ler
falser93912413fa_l_ser
falsie93513853fa_lsie_
falsies103515013fa_lsies
falterer11239873fa_lterer
falters103916473fa_lt_ers
fancier123412063fa_ncier
farrier103514893fa_rrier
farther1348343fa_rther
faster94625773fa_st_er
father125116713fa__ther
fatter94523213fa__tter
fatties103018203fa_tties
fatuities1246913fatuities
fault85428313fault___
faultfinder185843faultfinder
faultiness1344823faultiness
faultless1243163faultless
faults94513553fault__s
faulty12429363fault__y
fawnier13296363fa_wnier
fealties1139993fealties
featlier1136453featl_ier
feistier1136193feistier
filmier1237503f_ilmier
filter94517633f_ilt_er
filthier1434073f_ilthier
flaunter1135013flaunt_er
flier86023403f__l_ier
flintier1136393flintier
flirtier1144893flirtier
floatier1136983floatier
fluffier13264333fluffier
flukier14397853flu_kier
fluster103913063flust_er
fluter95316863flu_t_er
flutter104012093flu_tter
flytier13356503f_lytier
folkier14359043f_olkier
footier104115113f_ootier
fouler93614903foul__er
frailties1245853frailties
frettier1156593frettier
frillier1136513frillier
frontier1147313frontier
frostier1148163frostier
fruiter10309683fruit_er
frumpier1534173frumpier
fubsier12367763f_ubsier
fuggier12348963f_uggier
fuller94220383f_ul_ler
fumier11310903f_u_mier
funkier14349983f_unkier
funnier103210173f_unnier
furrier103513663f_urrier
further1337003f_urther
furzier19318103f_urzier
fussier103610673f_ussier
fuzzier18256523f_uzzier
gaudier938453gau_dier
gauleiter1042933gauleiter
gaunter82910713gaunt_er
gauzier1735633gau_zier
goutier82612353gou_tier
guiltier934493guiltier
gulfier1137793_gulfier
gulpier1046953_gulpier
gustier83813863_gustier
guttier83911103_guttier
halter94420883ha_lt_er
hastier103916623ha_stier
haughtier1642743haughtier
hauler95015123haul__er
hauliers1176713haul_iers
haunter103111153haunt_er
hulkier14328973_hulkier
joltier14318493_joltier
lustier73813503_lustier
malmier113611953ma_lmier
manlier92414023manl_ier
marlier92614783marl_ier
matier84321523ma__tier
mauler84416713maul__er
miltier93214963_miltier
mouldier1154963mouldier
moulter93812423moult_er
mustier94017963_mustier
nastier74115293na_stier
nattier73614623na_ttier
naughtier1343103naughtier
nuttier73112023_nuttier
outlier72216143_outlier
paintier1048793paintier
palier85023563pa_l_ier
pallier94417163pa_llier
palmier113312173pa_lmier
palter84423263pa_lt_er
paltrier1037543pa_ltrier
partier93520713pa_rtier
pastier94320383pa_stier
poulter93712013poult_er
poutier93215323pou_tier
pulpier1148623_pulpier
purtier93214093_purtier
puttier93314503_puttier
qualmier1934563qualmier
quartier1737543quartier
rallier73816273ra_llier
rattier74015593ra_ttier
rulier65016353_rul_ier
runtier73512853_runtier
rustier74416363_rustier
ruttier73412283_ruttier
sallier73320423sa_llier
salter64325083sa_lt_er
saltie63422433sa_ltie_
saltiers83411953sa_ltiers
salties73725773sa_lties
saltire73113043sa_ltire
saluter73512453salut_er
saucier9810283sau_cier
saunter72913453saunt_er
siltier73413863_siltier
sluttier836453sluttier
smuttier1035213smuttier
sulkier113811963_sulkier
sultrier837773_sultrier
talkier114011843ta_lkier
tallier72817213ta_llier
tartier74123263ta_rtier
tastier711817093ta_stier
tattier74216243ta_ttier
taunter73111453taunt_er
tauter64318023tau_t_er
trustier8268683trustier
tuftier1096603_tuftier
vastier103613203va_stier
vaulted11307193vault_ed
vaulters11206173vault_ers
vaultiest1234833vaultiest
vaulting12227233vaulting
vaunter10309603vaunt_er
vauntie1036633vauntie_
waltzer1934383wa_ltzer
wartier103413913wa_rtier

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 Limit1461621997.21620255.3
3Display Results1991990.0802487.5
 (SQL Overall)1786911997.70223200.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.