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

152 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
wheelie133619(None) 
wheelies1437861wheelies
sheenie10159492sheenie
steelie7310212steelie
theelin1038002theelin
weenie92612022w_eenie
weepie11258792w_eepie
wellie92814912w_ellie
wheedle1434822wheedle
wheel115515332wheel__
wheeled14318462wheeled
wheeler13298772wheeler
wheeling15318592wheeling
wheelmen1643312wheelmen
wheels123811712wheel_s
wheeple1534852wheeple
wheeze21276812whee_ze
wheezier2333342wheezier
wheylike2143402wheylike
beelike13379783_beelike
beeline93314723_beeline
belie75630383__belie
bheestie1343153bheestie
challie124012853challie
charlie123011923charlie
cheapie1437563cheapie
cheekier1735103cheekier
cheerier1348003cheerier
cheerio12379313cheerio
cheese113812763chee_se
cheesier1335963cheesier
chelae113614603ch_elae
creepie1137483creepie
eelier64216463__eelier
eerie55228533__eerie
ferlie92814053_ferlie
freebie1236043freebie
ghillie11326353ghillie
ghoulie1144263ghoulie
greenie8310123greenie
heel75034223_heel__
heeled104018413_heeled
heeler93917313_heeler
heeling113618513_heeling
heels85625533_heel_s
heeze175313483_hee_ze
heinie92512663_heinie
helio85321193_h_elio
helix154413013_h_elix
helve115018093_h_elve
hemline12311073_hemline
hempie132410563_hempie
henlike1448693_henlike
hoelike141411163_hoelike
hoolie93217783_hoolie
mealie82519813_mealie
nellie63614813_nellie
overlie102615013overlie
peerie83617893_peerie
preemie11310563preemie
scheelite1444203scheelite
shedlike1635833shedlike
sheenier11167423sheenier
sheenies111411543sheenies
sheetlike1644333sheetlike
sheeve123412843shee_ve
shekelim1742233shekelim
shellier1138393shellier
sheltie10109913sheltie
shelve124012763sh_elve
steelier839183steelier
steelies8312553steelies
sweetie10157873sweetie
theelins1137643theelins
theelol1044273theelol
treelike1237003treelike
wallie93216803w_allie
wavelike1836613wavelike
weblike1635923w_eblike
wedgie11428373w_edgie
weedier113810623w_eedier
weedlike1634393weedlike
weeklies1534913weeklies
weel75834083w_eel__
weenier103210803w_eenier
weenies102915093w_eenies
weepier12319273w_eepier
weepies122811743w_eepies
weevil1295433w_eevil
weewee12310083w_eewee
wellies103719073w_ellies
whale115517433wh_al_e
whalelike1943993whalelike
wheal115716183wheal__
wheals124512523wheal_s
whee105429593wh_e__e
wheedled1633033wheedled
wheedler1543543wheedler
wheedles1534643wheedles
wheedling1733073wheedling
wheelbase1772333wheelbase
wheelers14287733wheelers
wheelings16284933wheelings
wheelless1543763wheelless
wheelman1642813wheelman
wheelsmen1742083wheelsmen
wheen115016053whee__n
wheens124610613whee_ns
wheep136214353whee__p
wheeped16387503wheeped
wheeping17337103wheeping
wheepled1733293wheepled
wheeples1634743wheeples
wheepling1843323wheepling
wheeps14439953whee_ps
wheezed23296453wheezed
wheezer22296673wheezer
wheezes22306803wheezes
wheeziest2443663wheeziest
wheezily2642303wheezily
wheezing24315383wheezing
wheezy24244523whee_zy
whelk154311063wh_el_k
whelkier1833253whelkier
whelks16367323wh_elks
whelky19314973wh_elky
whelm134611983wh_el_m
whelmed16375153wh_elmed
whelms14377573wh_elms
whelp136012093wh_el_p
whelped16355633wh_elped
whelps14437843wh_elps
whence14187923wh_ence
where117019423wh_e_re
wherein13216593wherein
wherried15175013wherried
wherries14179023wherries
wherve15568113wh_erve
while115418693wh_il_e
whiplike2043813whiplike
whirlier14175293whirlier
whirlies14167373whirlies
whole114418093wh_ol_e
whoopie15295933whoopie
wienie9229973w_ienie
wifelier1434853wifelier
wifelike18135253wifelike
willie94116453w_illie
wirelike15167493wirelike
wiselier1137363wiselier
woolie93514483w_oolie
yeelin939343_yeelin

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.420425454.8
2DLD Change Limit1340271526.17321711.8
3Display Results1521520.0463304.3
 (SQL Overall)1786911526.63926915.3
 
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.