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

219 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
whizzes213471(None) 
whizzed2234061whizzed
whizzer2134581whizzer
whizzers2233421whizzers
wizzes175110771w_izzes
bizzes163910842_bizzes
fizzes174512552_fizzes
frizzes18338182frizzes
phizes20389132phi_zes
quizzes2435572quizzes
wheezes22306802wheezes
whiles124418012whi_les
whines125120102whi_nes
whinges143610632whinges
whishes16309442whishes
whites123919882whi_tes
whities133113252whities
whizz194210322whizz__
whizzier2233282whizzier
whizziest2342882whizziest
whizzy23274072whizz_y
winzes184313052w_inzes
wizes174723342w_i_zes
wizzen17387202w_izzen
wizzens18385482w_izzens
baizes174315053bai_zes
bizes165923663_bi_zes
blitzes18408703blitzes
buzzes165011173_buzzes
chazzen20214783chazzen
chazzens21253943chazzens
chicles143512503chicles
chides124620473chi_des
chigoes1338353chigoes
childes134211273childes
chiles115425303chi_les
chilies124218303chilies
chimes134922573chi_mes
chines115029173chi_nes
chintzes2235973chintzes
chirres123812253chirres
chives144317593chi_ves
chivies153412853chivies
cozzes164510893_cozzes
ditzes163212423_ditzes
dizzies16279753_dizzies
drizzles17295293drizzles
fezzes174910403_fezzes
fizzed18369443_fizzed
fizzer17369383_fizzer
fizzers18357003_fizzers
fizzles18339063_fizzles
friezes19418913friezes
fritzes19329453fritzes
frizes184015463fri_zes
frizzed19375973frizzed
frizzer18446893frizzer
frizzers19335103frizzers
frizzies19315933frizzies
frizzles19297283frizzles
fuzzes175412253_fuzzes
ghazies2036913ghazies
glitzes17367563glitzes
grizzles17286193grizzles
hazes174928323_h_azes
heezes184211643_heezes
hides95129423_hi_des
hies74842833_hi__es
hikes125426983_hi_kes
hinges105121033_hinges
hirees95117293_hirees
hires86134343_hi_res
hisses94719353_hisses
hives116925513_hi_ves
huzzas1735863_huzzas
jazzes21347883_jazzes
lezzes14387833_lezzes
maizes175115733mai_zes
mizzen16447953_mizzen
mizzens17366123_mizzens
mizzles17329493_mizzles
pizzas1646983_pizzas
pizzles17329273_pizzles
prizes173819813pri_zes
quizzed2534043quizzed
quizzer2434393quizzer
quizzers2542943quizzers
razzes144910073_razzes
rhizomes2243383rhizomes
ritzes154812943_ritzes
scuzzes1734403scuzzes
seizes154317533sei_zes
shies86136553shi__es
shikses14116573shikses
shines95028913shi_nes
shires95225573shi_res
shives124921413shi_ves
sizes146727763_si_zes
sizzles15349633_sizzles
spazzes1735263spazzes
spitzes1849183spitzes
swizzles1953783swizzles
thieves1346903thieves
tizzies15287893_tizzies
wahines133111173wahi_nes
waives123714183wai_ves
waltzes1935953waltzes
whales124716943wh_ales
wharves16457133wharves
wheeze21276813wheeze_
wheezed23296453wheezed
wheezer22296673wheezer
wheezers23265273wheezers
wheres125917433wh_eres
wherves16548053wherves
whicker19359773whicker
whickers20297983whickers
whidahs1743333whidahs
whidded1634423whidded
whids125413983whi__ds
whiffed2064473whiffed
whiffer19105323whiffer
whiffers2064493whiffers
whiffet1965343whiffet
whiffets2072523whiffets
whiffles2034263whiffles
whiffs1835083whi_ffs
whigs125612643whi__gs
while115418693whi_le_
whiled134514133whi_led
whimper17297723whimper
whimpers18276613whimpers
whims134515333whi__ms
whimsey18373893whimsey
whimseys19322463whimseys
whimsies1635193whimsies
whine116022813whi_ne_
whined134715203whi_ned
whiner124516633whi_ner
whiners134011573whiners
whiney155012643whi_ney
whinge134311543whinge_
whinged15409153whinged
whinger1410810913whinger
whingers15358723whingers
whinier134110633whinier
whiniest14298753whiniest
whinnies14237273whinnies
whins114922333whi__ns
whipped18379333whipped
whipper173611383whipper
whippers18329043whippers
whippet17328843whippet
whippets18255253whippets
whips134917083whi__ps
whirled14368043whirled
whirler13307603whirler
whirlers14286053whirlers
whirlies14167373whirlies
whirls124710533whi_rls
whirred14386933whirred
whirries14136693whirries
whirrs12408593whi_rrs
whirs115218093whi__rs
whished17428023whished
whishts16425313whishts
whisked18336913whisked
whisker17367933whisker
whiskers18306773whiskers
whiskey20445583whiskey
whiskeys21353383whiskeys
whiskies1835953whiskies
whisks16497353whi_sks
whisper15298013whisper
whispers16266993whispers
whisted144010013whisted
whistles14108213whistles
whists124613813whi_sts
white114920303whi_te_
whited134814083whi_ted
whiten124111923whi_ten
whitens13428733whitens
whiter124316393whi_ter
whitest133710113whi_test
whitey154911883whi_tey
whiteys16396153whiteys
whither163510253whither
whitier133311063whitier
whitiest14259883whitiest
whits115923823whi__ts
whitter139110893whitter
whitters14359403whitters
whittles1496673whittles
whiz195919943whi_z__
whizzing2333383whizzing
wholes124616773wh_oles
whores125617103wh_ores
wiches144418753w_iches
wides94832823w_i_des
wifes114522563w_i_fes
wiles85437873w_i_les
winces114819113w_inces
wines85546863w_i_nes
winoes94317013w_inoes
winze175014853w_inze_
wipes104827083w_i_pes
wires86034913w_i_res
wises85633193w_i_ses
wishes124920953w_ishes
wisses94619603w_isses
wites85536963w_i_tes
withes124620843w_ithes
wives115328923w_i_ves
wizen175813863w_i_zen
wizens186110263w_izens
wries85827743wri__es
writes94420333wri_tes
writhes134811703writhes
zizzles14307093_zizzles

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.423422437.4
2DLD Change Limit1340272195.62623822.8
3Display Results2192190.1062066.0
 (SQL Overall)1786912196.15529031.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.