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

268 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
daintier93740(None) 
dainties9312401dainties
paintier1048791paintier
daintiest1039152daintiest
daintily1245522daintily
dandier93714572da_ndier
daunter83811752daunt_er
dictier103411862d_ictier
dingier93513672d_ingier
dinkier123411502d_inkier
dirtier83312092d_irtier
driftier1275122driftier
fainter103611052faint_er
flintier1136392flintier
gainlier965672gainlier
glintier945702glintier
jauntier1535232jauntier
lintier73613802_lintier
mintier93615992_mintier
painter93814562paint_er
pointier1038302pointier
rainier71614252rain_ier
saintlier954622saintlier
airier64619363_ai_rier
anther93715063_a_nther
antiar6317173_a_ntiar
antler64615553_a_ntler
antsier7410773_a_ntsier
artier63419733_a_rtier
auntie64317703_auntie_
aunties73920073_aunties
auntlier834903_auntlier
bairnlier1142233bairnlier
baiter84422553bai_t_er
banter84825333ba_nt_er
banties94324763ba_nties
barnier93213673barn_ier
battier93515713ba_ttier
bittier94211663_bittier
brainier102510223brain_ier
brinier93613463brin_ier
canities101519243canities
cannier94014163ca_nnier
canter85230113ca_nt_er
cattier93317073ca_ttier
chinkier17377363chinkier
chintzier2342653chintzier
clingier1155853clingier
cointer93616723coint_er
dabster1036703dabst_er
daffier1457833da_ffier
dafter104813343da_ft_er
daiker115113033dai__ker
dailies84219263dai_lies
daintiness1145963daintiness
dainty105311473daint__y
dairies84217733dai_ries
daisied93410013dai_sied
daisies84217093dai_sies
dallier84215373da_llier
damneder1243763damneder
damner95213433damn__er
dancer94817613da_n_cer
dander811222993da_n_der
dandies94121443da_ndies
dandler94414273da_ndler
danger83722823da_n_ger
dangler96912813da_ngler
danglier1056753danglier
danker114319663da_n_ker
darklier1335013darklier
darneder1033983darneder
darner74017303darn__er
darter75320363da_rt_er
dashier114311183da_shier
dater65332313da__t_er
daubier1037093da_ubier
daunder9348893daun_der
daunted93810193daunt_ed
daunters9329843daunt_ers
daunting103310403daunting
dautie72914693da_utie_
dauties83315763da_uties
dawtie103011093da_wtie_
dawties113312703da_wties
deifier113013123dei_fier
deities82621923dei_ties
denier74420693d_en_ier
dernier83011943dern_ier
diaster82813313diast_er
dicier94416233d_i_cier
dickier143512453d_ickier
dieter73516773d_iet_er
diether1147443d_iether
diner65632903d_in__er
dinger85323673d_in_ger
dingies93618243d_ingies
dinkies123716033d_inkies
dinner74217163d_in_ner
dinted84419843d_int_ed
dinting93520553d_inting
dippier123111393d_ippier
dirtied93210853d_irtied
dirties83119383d_irties
dishier113613403d_ishier
disinter9310673disint_er
dither104417683d_i_ther
ditsier83010293d_itsier
ditties83116983d_itties
ditzier17307963d_itzier
dizzier16317543d_izzier
dotier73917033d__otier
dottier83910923d_ottier
downier11299703down_ier
draftier1285263draftier
drainer83012843drain__er
drifter11348703drift_er
drinker12349473drin_ker
drippier1385043drippier
dungier9368583d_ungier
dustier83814133d_ustier
fainer94717243fain__er
fainted114211723faint_ed
fainters11349693faint_ers
fainting123312163fainting
faintish1446193faintish
fancier123412063fa_ncier
fattier103513463fa_ttier
faultier1135283faultier
fawnier13296363fawn_ier
feistier1136193feistier
finnier10319953_finnier
flauntier1243063flauntier
flirtier1144883flirtier
fringier1236543fringier
frontier1147313frontier
gaieties9310183gaieties
gainer74117493gain__er
gaiter73819503gai_t_er
gaunter82910713gaunt_er
ginnier8298983_ginnier
grainier9218893grain_ier
grittier9316263grittier
guiltier934493guiltier
hairier103111053hai_rier
handier113817443ha_ndier
hastier103916623ha_stier
haunter103111153haunt_er
hinkier143610793_hinkier
hinter94021303_hint_er
inkier104013783__inkier
inlier63615363__inlier
inter55028493__int_er
jointer14379713joint_er
kainite1149543kainite_
kainites1238793kainites
kinkier10319433_kinkier
laities7320343lai_ties
lankier113711633la_nkier
lingier84113383_lingier
linier64423793_lin_ier
linter64625343_lint_er
mainliner1144673mainliner
maintainer1243503maintainer
maltier93015483ma_ltier
mangier104114063ma_ngier
manlier92414023ma_nlier
matier84321523ma__tier
miltier93214963_miltier
mincier113512463_mincier
mingier103815293_mingier
minter84425103_mint_er
mistier93418713_mistier
mitier83620673_mi_tier
nastier74115293na_stier
nattier73614623na_ttier
niftier10328713_niftier
nittier73512243_nittier
painted104214633paint_ed
painters103013023paint_ers
paintiest11310563paintiest
painting113614423painting
panier84425503pa_n_ier
pannier93613353pa_nnier
panther12611443pa_nther
pantie84326473pa_ntie_
panties94230933pa_nties
partier93520713pa_rtier
pastier94320383pa_stier
pinier84024693_pin_ier
pitier84019823_pi_tier
pointer93814933point_er
printer93917303print_er
quainter1765903quaint_er
randier83618473ra_ndier
rangier83714353ra_ngier
ranter63826823ra_nt_er
rattier74015593ra_ttier
reinter73116843reint_er
rentier73618223_rentier
runtier73512853_runtier
sainted84114243saint_ed
sainting93215733sainting
saltier74318633sa_ltier
sandier84017843sa_ndier
sanities81219753sanities
sanitizer18126733sanitizer
santir6315243sa_nti_r
saunter72913453saunt_er
scantier10309983scantier
shiftier1436333shiftier
shinier104113143shin_ier
shirtier1137933shirtier
shittier1137303shittier
siltier73413863_siltier
sinter63625923_sint_er
skinnier1264893skinnier
slinkier12206933slinkier
slittier837003slittier
spinier93715163spin_ier
squintier1844473squintier
stingier9279123stingier
stinkier12278543stinkier
stinter73614513stint_er
swingier12267003swingier
tainted83512423taint_ed
tainting93613583tainting
tangier83013903ta_ngier
tartier74123263ta_rtier
tastier711817093ta_stier
tattier74216243ta_ttier
taunter73111453taunt_er
tawnier10318463tawn_ier
tentier73815923_tentier
tinier63622233_tin_ier
tinnier72910143_tinnier
tinter63923643_tint_er
twinier1037313twin_ier
twistier1134813twistier
vainer93714573vain__er
vanitied12138213vanitied
vanities111414493vanities
vastier103613203va_stier
vaultier1144293vaultier
vaunter10309603vaunt_er
vauntie1036633vauntie_
vawntie1343943vawntie_
veinier10269583vein_ier
vinier93716743_vin_ier
vintner1034833_vintner
waister103812383waist_er
waiter94321253wai_t_er
wanier93920683wa_n_ier
wanter94423053wa_nt_er
wartier103413913wa_rtier
whinier134110633whin_ier
whinnier14255003whinnier
whitier133311063whi_tier
wiftier13297733_wiftier
windier113412163_windier
wingier113413283_wingier
winier94522453_win_ier
winter94222803_wint_er
wintrier1136873_wintrier
wittier103910823_wittier
wristier1136863wristier
zanier154314713za_n_ier
zingier17369493_zingier

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 Filter1786911461620.1731032896.0
2DLD Change Limit1461622687.78018786.9
3Display Results2682680.0932881.7
 (SQL Overall)1786912688.04622208.7
 
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.