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

391 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
flirters1133793(None) 
flirter10318671flirter_
flitters114312171flitters
blisters104015082blisters
blurters10348372blurters
fainters11349692fainters
filisters1237002filisters
filters103816552f_ilters
firers94922682f_ir_ers
firmers124711442f_irmers
fitters104517752f_itters
flatters113814202flatters
flichters1774172flichters
flickers17338882flickers
fliers94417192fli__ers
flinders12439262flinders
flingers123410192flingers
flippers15338002flippers
flirted11428672flirte_d
flirtier1144892flirtier_
flirts95411482flirt__s
flites95122442fli_te_s
flitter103413902flitter_
flivvers1733112flivvers
floaters112711512floaters
flouters11419272flouters
flusters113811502flusters
fluters103713682fl_uters
flutters114010822flutters
fritters113810782fritters
glisters93912602glisters
glitters93710542glitters
klisters123910482klisters
lifters104313782_lifters
linters73822632_linters
listers74026532_listers
liters65429882_li_ters
litters73422572_litters
skirters12337242skirters
slitters84014132slitters
aborters1038573aborters
affirmers1742563affirmers
afflicters1852243afflicters
airers64922313_air_ers
alerter72111513alerter_
alieners889823alieners
aligners9117573aligners
aliners74717723ali_ners
alters64924223al__ters
averters11249513averters
baiters94619303bai_ters
barters94223033_barters
birders103913263_birders
birlers93813003_birlers
bisters93922613_bisters
biters83925243_bi_ters
bitters94920363_bitters
blasters104116143blasters
blatters104414093blatters
bleaters103412323bleaters
blighters1555743blighters
blinders113911143blinders
blinkers14388503blinkers
blister94415313blister_
blistery13418713blistery
blites84721213bli_te_s
blithers134711233blithers
blitzers19417153blitzers
bloaters103311023bloaters
blotters104110983blotters
blurter9419833blurter_
blusters104413893blusters
carters95327253_carters
charters134115583charters
chirpers15358133chirpers
chitters133711173chitters
citers85022983_ci_ters
clatters103313913clatters
clickers163910203clickers
climbers14318413climbers
clingers113810663clingers
clinkers14339833clinkers
clippers14368843clippers
clivers123411753cli_vers
cloisters1137433cloisters
clouters10399803clouters
clusters102912403clusters
clutters103210353clutters
clysters13227843clysters
cointers103616413cointers
courters103015373courters
critters103511323critters
darters84017603_darters
dieters83216433_dieters
dilaters92513063dilaters
diluters9288113diluters
drifters12417913drifters
elaters74420193el_aters
elites66027123eli_te_s
emitters10349643emitters
enlisters937113enlisters
fagoters1234863fagoters
fainter103611053fainter_
fairer95212063fair_er_
fairgoers1342013fairgoers
fairies103516043fairie_s
fairness1136563fairness
falters103916473f_alters
farcers124713443f_arcers
farers95924053f_ar_ers
farmers124315263f_armers
farriers113610743farriers
fearers104815273fear_ers
feasters11511563feasters
feigners1235483feigners
ferreters1246253ferreters
festers104121393f_esters
fetters103517903f_etters
fibbers144510603f_ibbers
fibers114717523f_i_bers
fibsters13126413fibsters
fifers125414923f_i_fers
fighters15269403fighters
filchers16286863filchers
filers94623723f_i_lers
filiates11412663filiate_s
filister1137403filister_
fillers104320213f_illers
fillisters1343873fillisters
filmers124211293f_ilmers
filter94517633f_ilter_
finders113717873f_inders
fingers113418433f_ingers
firer811229253f_ir_er_
fires85740753f_ir_e_s
firmer114712443f_irmer_
firths125113503f_irt_hs
fishers134714723f_ishers
fitter94120033f_itter_
fivers124420923f_i_vers
fixers165112983f_i_xers
fizzers18357003f_izzers
flaggers13328073flaggers
flakers143613273fl_akers
flamers124616363fl_amers
flangers123311373flangers
flankers15349303flankers
flappers15388383flappers
flares94521703flar_e_s
flashers143912653flashers
flattens11357483flattens
flatter103815963flatter_
flattery14338293flattery
flaunters1234513flaunters
flayers133912033fl_ayers
fleecers13325933fleecers
fleers96015793fl__eers
fleeter103210363fleeter_
flensers1135463flensers
fleshers14339443fleshers
flichter1664963flichter_
flicker163610623flicker_
flickery20365103flickery
flier86023403fli__er_
flies85630713fli__e_s
flinchers17295473flinchers
flinder11319873flinder_
flinger113710513flinger_
flinted114411893flinte_d
flintier1136393flintier_
flints95617453flint__s
flipper14389143flipper_
flirs85518933fli___rs
flirt87424753flirt___
flirtiest1236193flirtiest
flirting12319013flirting
flirty12499143flirt__y
flite85424963fli_te__
flited104616583fli_te_d
flits85625223fli_t__s
flitted114011643flitte_d
flittered13196253flittered
flivver1633043flivver_
floatels11295663floatels
floater104413353floater_
floggers13387863floggers
flooders12257833flooders
floorers11227573floorers
floppers15337463floppers
florets1039853flor_ets
flossers11307863flossers
flouter104311343flouter_
flowers133413173fl_owers
flubbers15346893flubbers
fluffers13335293fluffers
flunkers15347533flunkers
flushers14279733flushers
fluster103913063fluster_
fluter95316863fl_uter_
flutes95421783fl_ute_s
flutter104012093flutter_
fluttery14376143fluttery
flyers125712803fl__yers
flyovers1733673flyovers
flytes123911563fl_yte_s
flytiers14254483flytiers
foliates11412753foliate_s
footers104618333f_ooters
forcers124215713f_orcers
forgers115218183f_orgers
forkers144615783f_orkers
formers128217953f_ormers
fortes95327183f_orte_s
fosters104220103f_osters
fraters103517213f_raters
freers94717303f__reers
fretters113410303fretters
friers94718933f__riers
frillers11349873frillers
friskers15337373friskers
frites94922483fri_te_s
fritter103912773fritter_
frizers19329553fri_zers
frizzers19335103frizzers
fruiters11328183fruiters
fryers125710973f__ryers
fuhrers1334813fuhr_ers
furlers104214223f_urlers
furriers11369493furriers
furthers1436493f_urthers
gaiters83516543gai_ters
garters84218233_garters
girders9379943_girders
gliders94811843gli_ders
glimmers13396153glimmers
glistens9366593glistens
glister84013343glister_
glitter84211803glitter_
glittery12375613glittery
gloaters9288863gloaters
goiters84014443goi_ters
grifters12389233grifters
gristers94013403gristers
gritters94210633gritters
heisters113413133heisters
hinters103719583_hinters
hirers94518063_hir_ers
hitters104717593_hitters
hoisters113513483hoisters
hurters103413643_hurters
inflicters1543453inflicters
inters64328053__inters
jilters144211963_jilters
jitters144314473_jitters
jointers15289323jointers
keisters123212043keisters
kilters113813603_kilters
kiters105218593_ki_ters
klister113410643klister_
knitters12336623knitters
larders83516943_larders
larkers113014513_larkers
lasters75627693_lasters
leisters83312823leisters
letters73819853_letters
libbers113812833_libbers
libers84721443_li_bers
lickers134118253_lickers
lictors93212593_lictors
liers55130403_li__ers
lifers95617843_li_fers
lifter93814813_lifter_
ligers75022043_li_gers
lighters123111393_lighters
likers104620913_li_kers
limbers113614743_limbers
limiters10249333_limiters
limmers113413083_limmers
limners93311563_limners
limpers113815223_limpers
liners65428853_li_ners
lingers84223303_lingers
linkers114317713_linkers
lintels73311163_lintels
linter64625343_linter_
lippers113416443_lippers
lispers94514323_lispers
listees73416673_listees
listels74212433_listels
listens74014133_listens
lister64527253_lister_
liter54736343_li_ter_
litres65220393_litre_s
litter64324853_litter_
littery103710493_littery
livers94927823_li_vers
liviers104211073_liviers
livyers13365903_livyers
lofters103912903_lofters
loiters74116613_loiters
looters74419163_looters
lotters73921063_lotters
lurers64217493_lur_ers
lurkers113910083_lurkers
lusters73921443_lusters
meisters103313843meisters
milters93619093_milters
minters93822473_minters
misters93927513_misters
miters84328783_mi_ters
niters64624213_ni_ters
oldsters996733oldsters
omitters10277653omitters
painters103013023painters
philters1398173philters
plaisters1137813plaisters
plaiters103512633plaiters
planters102915323planters
plasters103518133plasters
platers93924093pl_aters
platters103415283platters
pleaters103613793pleaters
pliers84715153pli__ers
plighters1545533plighters
plinkers14309393plinkers
plotters104011553plotters
pointers103013723pointers
porters93722703_porters
printers103214903printers
quarters173110453quarters
quieters17248733quieters
quilters17228433quilters
quitters17238523quitters
reinters82614773reinters
rioters73615513_rioters
ritters74020623_ritters
roisters83615553roisters
shifters14319863shifters
shirkers15319583shirkers
sifters103714793_sifters
sinters74024083_sinters
sisters73721593_sisters
sitters74221553_sitters
skirter11338483skirter_
skitters12349553skitters
slaters73123733sl_aters
slicers94114923sli_cers
slickers143112553slickers
sliders83515223sli_ders
slighters1346713slighters
slimmers12369633slimmers
slingers93712683slingers
slippers123711233slippers
slithers114212953slithers
slitter73615873slitter_
slivers104115253sli_vers
slotters84012403slotters
smirkers14316353smirkers
smiters93414363smi_ters
snifters11318613snifters
snorters83410583snorters
sorters74221133_sorters
spitters104113383spitters
splinters11277923splinters
splitters11307323splitters
sporters103714063sporters
spurters103311703spurters
squirters1835073squirters
starters83714773starters
stinters83312753stinters
stirrers8266943stirrers
suiters73618883sui_ters
swifters14277483swifters
thirsters1235233thirsters
tilters73315953_tilters
tinters74221113_tinters
titers64526413_ti_ters
titters74219623_titters
twirlers11274303twirlers
twisters11268173twisters
twitters11296773twitters
ulsters72711983ul_sters
uniters73814173uni_ters
uplifters1463283uplifters
waisters113811523waisters
waiters104218623wai_ters
whirlers14286053whirlers
whitters14359403whitters
winters103720483_winters
wirers94617893_wir_ers
writers105513493wri_ters

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 Limit1461623917.32619951.1
3Display Results3913910.1562506.4
 (SQL Overall)1786913917.90522604.8
 
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.