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

164 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
guiltier93449(None) 
glintier945702glintier
grittier9316262grittier
guilder945912guil_der
guiltiest1035712guiltiest
guiltily1243422guiltily
gulfier1137792gu_lfier
gulpier1046952gu_lpier
gustier83813862gu_stier
guttier83911102gu_ttier
miltier93214962_miltier
quilter16279802quilt_er
siltier73413862_siltier
auntlier834903auntlier
bilgier10358533_bilgier
bittier94211663_bittier
builder1037573buil_der
bulgier103911213bu_lgier
bulkier134111513bu_lkier
bullier94116433bu_llier
burlier93514413burl_ier
bustier93916153bu_stier
chillier13328423chillier
curlier93314183curl_ier
daintier937403daintier
dictier103411863_dictier
dirtier83312093_dirtier
driftier1275123driftier
dustier83814133du_stier
faultier1135283faultier
feistier1136193feistier
filmier1237503_filmier
filter94517633_filt_er
filthier1434073_filthier
flintier1136393flintier
flirtier1144893flirtier
frillier1136513frillier
fruitier1136593frui_tier
fusilier1135433fusil_ier
fustier104213933fu_stier
gaieties9310183gaieties
gainlier965673gainlier
gaiter73819503gai_t_er
ghillie11326353ghillie_
ghillies12408663ghillies
ghostier1235383ghostier
giddier10308723g_iddier
gilder84415533g_il_der
giller74519733g_il_ler
gillie74816943g_illie_
gillied95512313g_illied
gillies84120963g_illies
gimpier12247943g_impier
ginnier8298983g_innier
girlier8289523g_irlier
gleetier934913gleetier
glister84013343glist_er
glitter84211803gli_tter
glitzier1833593glitzier
gluier7310263g__luier
gnattier934263gnattier
godlier938893godl_ier
goiter74116203goi_t_er
goutier82612353g_outier
grifter113810493grift_er
griller84513353gril_ler
grimier103210433gri_mier
gripier103210323gri_pier
grippier1355203grippier
grislier935793grislier
grister83915413grist_er
gristlier1044283gristlier
gritter83913353gri_tter
grottier9316673grottier
groutier9297173groutier
guider84313523gui__der
guilders1035513guil_ders
guile64521133guil__e_
guiled84315383guil__ed
guiles73919283guil__es
guiling93214213guil_ing
guilt65125573guilt___
guiltiness1144203guiltiness
guiltless1043023guiltless
guilts74111233guilt__s
guilty10418233guilt__y
guitar7117443gui_t_ar
gullied93812063gu_llied
gullies84717313gu_llies
gulper93410213gu_l_per
gummier12349473gu_mmier
gunkier12369553gu_nkier
gushier113110073gu_shier
gutsier8389823gu_tsier
gutter73817713gu__tter
guttler8369163gu_ttler
hillier103413963_hillier
hulkier14328973hu_lkier
jilter133512513_jilt_er
joltier14318493_joltier
juicier1635463jui_cier
kilter103714343_kilt_er
kiltie103210963_kiltie_
kilties113014143_kilties
lintier73613803_lintier
lustier73813503lu_stier
maltier93015483_maltier
milkier133411163_milkier
millier93716703_millier
milter84921233_milt_er
mintier93615993_mintier
mistier93418713_mistier
mitier83620673_mi_tier
mustier94017963mu_stier
niftier10328713_niftier
nittier73512243_nittier
nuttier73112023nu_ttier
oilier64417233_oil_ier
outlier72216143outl_ier
paintier1048793paintier
philter12108213philt_er
pitier84019823_pi_tier
pointier1038303pointier
pulpier1148623pu_lpier
purtier93214093pu_rtier
puttier93314503pu_ttier
qualmier1934563qualmier
quartier1737543quartier
quieter162810333quiet_er
quilted17319313quilt_ed
quilters17228433quilt_ers
quilting18218713quilting
quippier2133773quippier
quirkier2134163quirkier
quitter162910753qui_tter
roilier7311523roil_ier
rulier65016353ru_l_ier
runtier73512853ru_ntier
rustier74416363ru_stier
ruttier73412283ru_ttier
saltier74318633_saltier
shiftier1436343shiftier
shirtier1137943shirtier
shittier1137313shittier
silkier114411643_silkier
sillier74017593_sillier
slittier837003slittier
squintier1844473squintier
stillier868823stillier
suiter64121813sui_t_er
sulkier113811963su_lkier
sultrier837773su_ltrier
surlier72915443surl_ier
tilter63417693_tilt_er
tuftier1096603tu_ftier
twistier1134813twistier
uglier748953_ugl_ier
uglifier1244503uglifier
vaultier1144293vaultier
whitier133311063whi_tier
wiftier13297733_wiftier
wilier93217073_wil_ier
wittier103910823_wittier
wristier1136863wristier

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.423422437.4
2DLD Change Limit1461621646.56322270.6
3Display Results1641640.0602733.3
 (SQL Overall)1786911647.04625360.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.