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

177 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
leftwing153297(None) 
clefting14347582cleft_ing
hefting144510912heft_ing
letting83218532le_tting
lifting113313272lift_ing
lofting113311312loft_ing
alerting91312383alert_ing
batwing13509813_batwing
beating104326873beat_ing
bedewing1537143bedewing
beeswing14255763beeswing
beetling1139283beetling
befitting15236623befitting
belting104119133belt_ing
berthing14209593berthing
besting104923923best_ing
bestowing1535803bestowing
betting103921403be_tting
bleating113514503bleat_ing
centring112112953centring
clearwing1533673clearwing
cleating113518133cleat_ing
clewing13359583cle__wing
defacing15238683defacing
defaming15238463defaming
defatting1436103defatting
defiling132812463defiling
defining133711803defining
defusing13227933defusing
defuzing22195253defuzing
defying15328823def_ying
denting94422183dent_ing
dewing114115703de__wing
eating75134403_eat_ing
elating83423083elat_ing
elbowing1435013elbowing
electing112113783elect_ing
eluting84115293elut_ing
entwine1039143_entwine
felting113515213felt_ing
feting104417793fe_t_ing
fetting113517873fe_tting
fettling1266773fettling
fleeting122910323fleet_ing
gentling1048453gentling
getting93316563ge_tting
gifting123810893gift_ing
gleeting10279173gleet_ing
hafting144014173haft_ing
heating114024323heat_ing
henting113719653hent_ing
hewing134514243he__wing
jesting154317713jest_ing
jetting153815343je_tting
jettying1933953jettying
jewing174411423je__wing
lacewing1435843lacewing
lapwing13308263l_apwing
lasting84725243last_ing
lathing114315693l_athing
lawing104625283l__awing
leaching143012833leaching
leading93419553le_ading
leafing113313583le_afing
leaguing1035343leaguing
leaking123616973le_aking
leaning83721203le_aning
leaping103215993le_aping
learning978553learning
leashing123310313leashing
leasing83920163le_asing
leaving114216853le_aving
leching134613653le_ching
lectin82515013lect_in_
lectins92515003lect_ins
lecturing1237303lecturing
leeching14318373leeching
leering83417643le_ering
lefties10312073left_ies
leftish13197253left_ish
leftism12226093left_ism
leftist10279353left_ist
leftward1562733leftward
legating102313113legating
legging103912643le_gging
lekking11306503le_kking
lemming12269393le_mming
lending94118533le_nding
leniting9312353leniting
lensing84015103le_nsing
leptin82512333lept_in_
leptins92412693lept_ins
letching143810263letching
lettering102112073lettering
leveeing12265963leveeing
leveling122910433leveling
levering122212503levering
levying1435873le_vying
lilting83515383lilt_ing
linting83820983lint_ing
listing84020593list_ing
loathing1247673loathing
looting83019643loot_ing
lotting82917753l_otting
louting83719383lout_ing
lowing104623273l__owing
luffing143310103luf_fing
lunting83817743lunt_ing
lusting83619323lust_ing
lustring9269723lustring
luting75221753l_ut_ing
meeting103314963meet_ing
melting103317753melt_ing
meowing1368593me_owing
meting94320593me_t_ing
metring103215293me_tring
mewing123914203me__wing
nesting84320443nest_ing
nestling958893nestling
netting84018763ne_tting
nettling957213nettling
pelting102917273pelt_ing
pestling111010253pestling
petting103720953pe_tting
pettling1168213pettling
pleating112916053pleat_ing
rafting113815753raft_ing
redwing122811983re_dwing
refacing142512813refacing
reffing143712173ref_fing
refiling123116533refiling
refining122416863refining
refiring123513923refiring
refitting132811123refitting
refixing19329793refixing
reflowing1636523reflowing
reflying15268173reflying
refrying15278903refrying
refuging13218423refuging
refusing122310873refusing
refuting121911903refuting
renewing121910713renewing
renting84026853rent_ing
resawing122311433resawing
resewing122712263resewing
resowing123111523resowing
resting85031183rest_ing
restring91518783restring
retting83425883re_tting
retying113213833re_tying
rifting113515003rift_ing
seating84130683seat_ing
seething1239023seething
setting83621393se_tting
settling978943settling
sewing103819623se__wing
sifting113014593sift_ing
sleeting93114163sleet_ing
sleuthing1334203sleuthing
slewing113311353sle__wing
sweptwing1841693sweptwing
teething1237163teething
tenting84621153tent_ing
testing86021053test_ing
tewing103914823te__wing
tufting11289873tuft_ing
venting114218093vent_ing
vesting114618683vest_ing
vetoing11309053ve_toing
vetting114216563ve_tting
wafting143911663waft_ing
weeting113816053weet_ing
weftwise1741813weftwise
welting113615313welt_ing
westing115020273west_ing
wetting114117383we_tting
zesting174515333zest_ing

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.453394461.4
2DLD Change Limit1461621777.17320376.7
3Display Results1771770.0762328.9
 (SQL Overall)1786911777.70223200.6
 
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.