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

320 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
paintier104879(None) 
daintier937401daintier
painter93814561paint_er
pointier1038301pointier
dainties9312402dainties
fainter103611052faint_er
flintier1136392flintier
gainlier965672gainlier
glintier945702glintier
jauntier1535232jauntier
lintier73613802_lintier
mintier93615992_mintier
painted104214632paint_ed
painters103013022paint_ers
paintiest11310562paintiest
painting113614422painting
panier84425502pa_n_ier
pannier93613352pa_nnier
panther12611442pa_nther
pantie84326472pa_ntie_
panties94230932pa_nties
partier93520712pa_rtier
pastier94320382pa_stier
pinier84024692p_in_ier
pitier84019822p_i_tier
pointer93814932point_er
printer93917302print_er
rainier71614262rain_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
brainier102510233brain_ier
brinier93613473brin_ier
canities101519263canities
cannier94014163ca_nnier
canter85230113ca_nt_er
cattier93317073ca_ttier
chinkier17377363chinkier
chintzier2342663chintzier
clingier1155853clingier
cointer93616723coint_er
daintiest1039153daintiest
daintily1245523daintily
dandier93714573da_ndier
daunter83811753daunt_er
dictier103411863_dictier
dingier93513673_dingier
dinkier123411503_dinkier
dirtier83312093_dirtier
driftier1275123driftier
fainer94717243fain__er
fainted114211723faint_ed
fainters11349693faint_ers
fainting123312163fainting
faintish1446193faintish
fancier123412063fa_ncier
fattier103513463fa_ttier
faultier1135283faultier
fawnier13296363fawn_ier
feistier1136193feistier
finnier10319953_finnier
flauntier1243063flauntier
flirtier1144893flirtier
fringier1236553fringier
frontier1147313frontier
gaieties9310183gaieties
gainer74117493gain__er
gaiter73819503gai_t_er
gaunter82910713gaunt_er
ginnier8298983_ginnier
grainier9218903grain_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
maintainer1243513maintainer
maltier93015483ma_ltier
mangier104114063ma_ngier
manlier92414023ma_nlier
matier84321523ma__tier
miltier93214963_miltier
mincier113512473_mincier
mingier103815293_mingier
minter84425103_mint_er
mistier93418713_mistier
mitier83620673_mi_tier
nastier74115293na_stier
nattier73614623na_ttier
niftier10328713_niftier
nittier73512243_nittier
pacier105018683pa__cier
pacifier1557503pacifier
painches1588913painches
pained95622853pain__ed
paining103920243pain_ing
painkiller1662153painkiller
paint75443693paint___
painterly1443313paint_erly
paintings12327093paintings
paints85921833paint__s
paintwork1843013paintwork
painty114714753paint__y
palier85023563pa__lier
pallier94417163pa_llier
palmier113312173pa_lmier
palter84423263pa_lt_er
paltrier1037523paltrier
pander93725523pa_n_der
pandied113913443pa_ndied
pandies104224503pa_ndies
panickier1743173panickier
paniers94717333pa_n_iers
panner84224763pa_n_ner
panniers10488853pa_nniers
pansies94521983pa_nsies
panted95024823pa_nt_ed
panthers13510783pa_nthers
pantile93918483pa_ntile
pantiled113111593pa_ntiled
pantiles103617153pa_ntiles
panting104025423pa_nting
pantries101817393pa_ntries
panzer174213233pa_n_zer
pappier103511593pa_ppier
parities10522973parities
parrier93717653pa_rrier
partied103516553pa_rtied
partiers103514243pa_rtiers
parties93230863pa_rties
partner92811393pa_rtner
partyer12337873pa_rtyer
paster85734373pa_st_er
pastie85525523pa_stie_
pasties94529813pa_sties
patchier15319663patchier
pater74740723pa__t_er
patienter1145553patient_er
patissier1143183patissier
patter84628263pa__tter
pattie84020963pa_ttie_
patties93425143pa_tties
patzer173111643pa__tzer
paunchier1643333paunchier
pawkier16236613pa_wkier
pawner114212923pawn__er
peatier94017233p_eatier
pestier94317403p_estier
pettier94213613p_ettier
philter12108213philt_er
phonier122710633phon_ier
piaster93012883piast_er
pickier153912973p_ickier
pieties9419223p_ieties
piggier113510003p_iggier
pincer104019173p_in_cer
pincher143812713p_incher
pinder94523453p_in_der
pinger94324093p_in_ger
pinite8321243p_inite_
pinites9319533p_inites
pinker125322443p_in_ker
pinkie124414273p_inkie_
pinkies133818263p_inkies
pinner84521503p_in_ner
pinnies93318443p_innies
pintle83818263p_intle_
pintles94118723p_intles
pintoes95117713p_intoes
pipier104913983p_i_pier
pithier123010293p_ithier
pitied94017253p_i_tied
pitiers93812653p_i_tiers
pities83828083p_i_ties
plainer93811983plain__er
plaintiff1742663plaintiff
plaintive1444623plaintive
plaister1068013plaist_er
plaiter93615393plai_t_er
planter94017803plant_er
platier93716293p_latier
plenties10314693plenties
plinker134010963plin_ker
plottier10327263plottier
plunkier14305323plunkier
pointe84619313point_e_
pointed103813983point_ed
pointers103013723point_ers
pointes93216753point_es
pointiest1139623pointiest
pointing112813683pointing
pointmen1245423pointmen
pornier93413133porn_ier
pottier93516493p_ottier
poutier93215323p_outier
prettier1069043prettier
pricier113313113pri_cier
prickier16368143prickier
prinker133412743prin_ker
printed104016373print_ed
printers103214903print_ers
printery13318433print_ery
printing113216083printing
prissier10157873prissier
privier122910453pri_vier
punier84519223p_un_ier
punkier133512793p_unkier
punnier93511263p_unnier
punter84320023p_unt_er
punties94520783p_unties
purtier93214093p_urtier
puttier93314503p_uttier
quainter1765903quaint_er
randier83618473ra_ndier
rangier83714353ra_ngier
ranter63826823ra_nt_er
rattier74015593ra_ttier
reinter73116843reint_er
rentier73618223_rentier
runtier73512853_runtier
sainted84114243saint_ed
sainting93215733sainting
saltier74318633sa_ltier
sandier84017843sa_ndier
sanities81219773sanities
sanitizer18126733sanitizer
santir6315253sa_nti_r
saunter72913453saunt_er
scantier10309983scantier
shiftier1436343shiftier
shinier104113143shin_ier
shirtier1137943shirtier
shittier1137313shittier
siltier73413863_siltier
sinter63625923_sint_er
skinnier1264893skinnier
slinkier12206933slinkier
slittier837003slittier
spinier93715163spin_ier
splinter10329703splint_er
springier1236023springier
sprinter103810813sprint_er
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.406440125.6
2DLD Change Limit1461623207.76618820.8
3Display Results3203200.1262539.7
 (SQL Overall)1786913208.29821534.2
 
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.