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

280 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
whiteys1639615(None) 
whitens13428731whitens
whites123919881white_s
whitey154911881whitey_
waiters104218622waiters
wheys145911552wh__eys
whiles124418012while_s
whimseys19322462whimseys
whiners134011572whiners
whines125120102whine_s
whiney155012642whiney_
whiskeys21353382whiskeys
white114920302white__
whited134814082white_d
whitely16346472whitely
whiten124111922white_n
whiter124316392white_r
whitest133710112whitest
whities133113252whities
whits115923822whit__s
whitters14359402whitters
whity145513472whit_y_
wifeys15425872w_ifeys
wites85536962w_ite_s
witneys13274722w_itneys
writers105513492writers
writes94420332write_s
awaiters1146643awaiters
axites134913833axite_s
baileys12388933baileys
baiters94619303baiters
biters83925243_biters
bites75641173_bite_s
blites84721213blite_s
boites84322703boite_s
chanteys16387493chanteys
chiders135312943chiders
chides124620473chide_s
chiefs14509653chi_efs
chiels115115933chi_els
chiles115425303chile_s
chimers144515143chimers
chimes134922573chime_s
chimleys1883633chimleys
chimneys1883643chimneys
chines115029173chine_s
chisels12219103chisels
chitins122713793chitins
chitons122611913chitons
chits105424573chit__s
chitters133711173chitters
chitty14329433chitty_
chives144317593chive_s
chutes114615773chute_s
chutneys1642323chutneys
citers85022983_citers
cites74435593_cite_s
cuteys11569983_cuteys
dites66339153_dite_s
elites66027123elite_s
evites94916473evite_s
flites95122443flite_s
frites94922483frite_s
gaiters83516543gaiters
gites65630183_gite_s
goiters84014443goiters
haters94930403_haters
hates86742573_hate_s
hickeys19508223_hickeys
hiders104919653_hiders
hides95129423_hide_s
hies74842833_hi_e_s
hikers135014353_hikers
hikes125426983_hike_s
hinters103719583_hinters
hirees95117293_hirees
hirers94518063_hirers
hires86134343_hire_s
hitless103211193_hitless
hits75545133_hit__s
hitters104717593_hitters
hives116925513_hive_s
homeys145012873_homeys
honeys124016083_honeys
hooeys125512313_hooeys
hoseys124614003_hoseys
hotels94515513_hotels
items7499613__items
jitneys17313173_jitneys
kiters105218593_kiters
kites95432543_kite_s
limeys11429273_limeys
liters65429883_liters
loiters74116613loiters
mateys115610943_mateys
miters84328783_miters
mites75141803_mite_s
niters64624213_niters
nites55736343_nite_s
ophites12310103ophite_s
philters1398173philters
phizes20389133phize_s
phoneys15437143phoneys
rites54442553_rite_s
shanteys14395513shanteys
shiels95418923shi_els
shiers94921753shi_ers
shies86136553shi_e_s
shifters14319863shifters
shindys14314133shindys
shiners104015943shiners
shines95028913shine_s
shinneys14275093shinneys
shires95225573shire_s
shitless11249243shitless
shits84731173shit__s
shitty124110063shitty_
shivers133714833shivers
shives124921413shive_s
shotes95321913shote_s
shutes93518223shute_s
shuteye1343363shuteye
shuteyes1443473shuteyes
sites56045433_site_s
skites104418043skite_s
smileys12336323smileys
smiters93414363smiters
smites83921923smite_s
spites84127333spite_s
suiters73618883suiters
suites63727403suite_s
titers64526413_titers
uniters73814173uniters
unites65024853unite_s
wafters134112813wafters
wahines133111173wahine_s
wailers103916803wailers
waisters113811523waisters
waited103819773waite_d
waiter94321253waite_r
waitress1135223waitress
waits88333523wait__s
waivers133410053waivers
waives123714183waive_s
wanters104420093wanters
wasters104026593wasters
wastes96224883waste_s
waters95030633w_aters
waveys15597013w_aveys
weiners103913063weiners
welters103516063welters
westers105221963westers
wetters103817753wetters
whalers13529703whalers
whales124716943whale_s
whatness1435093whatness
whats117718993what__s
whatsis1335253whatsis
wheatens1454663wheatens
wheels123811713wh_eels
wheens124610613wh_eens
wheeps14439953wh_eeps
whens114618763wh__ens
whereas13448903whereas
wheres125917433where_s
whets115019613wh__ets
whetters14246653whetters
whews145114493wh__ews
whey135018713wh__ey_
wheyey1834323wheyey_
whickers20297983whickers
whidahs1743333whidahs
whids125413983whi__ds
whiffers2064493whiffers
whiffets2072523whiffets
whiffs1835083whi_ffs
whigs125612643whi__gs
while115418693while__
whiled134514133while_d
whimpers18276613whimpers
whims134515333whi__ms
whimsey18373893whimsey_
whimsy17375223whimsy_
whine116022813whine__
whined134715203whine_d
whiner124516633whine_r
whingers15358723whingers
whinges143610633whinges
whinny15587493whinny_
whins114922333whi__ns
whiny144915573whi_ny_
whippers18329043whippers
whippets18255253whippets
whippy19385843whippy_
whiprays1942503whiprays
whips134917083whi__ps
whirlers14286053whirlers
whirls124710533whi_rls
whirly15448863whirly_
whirrs12408593whi_rrs
whirry15477063whirry_
whirs115218093whi__rs
whishes16309443whishes
whishts16425313whishts
whiskers18306773whiskers
whiskey20445583whiskey_
whisks16497353whi_sks
whisky19455903whisky_
whispers16266993whispers
whisted144010013whiste_d
whistlers1595163whistlers
whistles14108213whistles
whists124613813whi_sts
whit104834173whit___
whitecap1842713whitecap
whitecaps1942763whitecaps
whitefish2143073whitefish
whitefly2042513whitefly
whitened1535173whitened
whitener1435733whitener
whiteners1535243whiteners
whiteness1546483whiteness
whiteout1445583whiteout
whiteouts1543173whiteouts
whitewash2152703whitewash
whither163510253whither
whitier133311063whitier
whitiest14259883whitiest
whiting143311303whiting
whitings15287063whitings
whitish1635973whitish
whitlow1642853whitlow
whitlows1743083whitlows
whitter139110893whitter
whittle13106103whittle
whittlers1594333whittlers
whittles1496673whittles
whittrets1542493whittrets
whizzers2233423whizzers
whizzes2134713whizzes
whizzy23274073whizzy_
wholes124616773whole_s
whores125617103whore_s
whys137011663wh___ys
widens106212723w_idens
wides94832823w_ide_s
wifes114522563w_ife_s
wifey144913673w_ifey_
wiles85437873w_ile_s
winceys15395523winceys
wines85546863w_ine_s
winey115325433w_iney_
winters103720483winters
wipers115416083w_ipers
wipes104827083w_ipe_s
wirers94617893w_irers
wires86034913w_ire_s
wises85633193w_ise_s
witans93412933w_itans
wite75443273w_ite__
wited94727143w_ite_d
withers134417753w_ithers
withes124620843w_ithes
withy144813763w_ithy_
witless103310983w_itless
witness103010013w_itness
witney12356843w_itney_
wits76044873w_it__s
witty114717013w_itty_
wivers125320803w_ivers
wives115328923w_ive_s
wizens186110263w_izens
wizes174723343w_ize_s
wries85827743wri_e_s
write85522833write__
writer94416513write_r
writhers14398983writhers
writhes134811703writhes
writs86624383writ__s
wytes114113433w_yte_s

Search took 7 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 Filter1786911340270.436409841.7
2DLD Change Limit1340272806.09321996.9
3Display Results2802800.0933010.8
 (SQL Overall)1786912806.62226984.4
 
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.