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

130 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
clearwing153367(None) 
clearing113014881clear_ing
clearwings1651701clearwings
blearing113111942blear_ing
clawing133812672cl_a_wing
cleaning113112382clea_ning
cleansing1235072cleansing
clearings12286062clear_ings
cleating113518132clea_ting
cleaving141389682clea_ving
clerking15257162cle_rking
clewing13359582cle__wing
learning978552_learning
alarming1138583al_arming
alerting91312383ale_rting
anearing9413973anear_ing
bearding124011943_bearding
bearing103624773_bear_ing
blaring104317113bl_ar_ing
blawing134012753bl_a_wing
bleaching17287093bleaching
bleating113514503blea_ting
carding113922433c__arding
caring95137993c__ar_ing
carking144322853c__arking
carling103727063c__arling
carping123521083c__arping
carting104228283c__arting
carving133916773c__arving
cawing124322613c__a_wing
ceasing104118263c_ea_sing
cellaring1238523cellar_ing
cering94522533c_e_r_ing
charging152910773c_harging
charing133721323c_har_ing
charking183512613c_harking
charming163012033c_harming
charring142913163c_harring
charting142614193c_harting
chawing164813033c_ha_wing
cheating144014523chea_ting
cheering143612703cheer_ing
chewing163911143che__wing
clacking173313493cl_acking
cladding1337143cl_adding
clagging13328873cl_agging
claiming13279303cl_aiming
clamming15329373cl_amming
clamping154011153cl_amping
clanging124012123cl_anging
clanking154313063cl_anking
clapping153810603cl_apping
clashing143812193cl_ashing
clasping133310263cl_asping
classing113211793cl_assing
claying133614303cl_a_ying
clearweed1542153clearweed
cleeking15267813cle_eking
clefting14347583cle_fting
clenching17266303clenching
cleping123310423cle__ping
cloaking15299713cloa_king
clouring112811273clour_ing
coercing1349003coe_rcing
coleading1338523colea_ding
collaring12310543collar_ing
covarying1844133covarying
creaking153414123crea_king
creaming133413143crea_ming
creasing113314443crea_sing
creating113921953crea_ting
crewing133212633cre__wing
earing75235483__ear_ing
earning83418213__earning
earring83519013__earring
earwig10114703__earwi_g
fearing113520033_fear_ing
flaring114116803fl_ar_ing
flawing143812563fl_a_wing
fleering123811283fleer_ing
gearing92818843_gear_ing
glaring93714883gl_ar_ing
gleaming12277933glea_ming
gleaning10269323glea_ning
hearing113324163_hear_ing
hearsing1239383_hearsing
hearting12513123_hearting
lapwing13308263_l_apwing
larding92917873_l_arding
larking123718253_l_arking
lawing104625283_l_a_wing
leaching143012833_leaching
leading93419553_lea_ding
leafing113313583_lea_fing
leaguing1035343_leaguing
leaking123616973_lea_king
leaning83721203_lea_ning
leaping103215993_lea_ping
learnings1094323_learnings
leashing123310313_leashing
leasing83920163_lea_sing
leaving114216853_lea_ving
leering83417643_leer_ing
leftwing1532973_leftwing
nearing83020333_near_ing
overawing16710293overawing
pearling11912013_pearling
pleaching17257083pleaching
pleading123011443plea_ding
pleasing112611593plea_sing
pleating112916053plea_ting
prearming14139223prearming
rearing83128783_rear_ing
rearming111413613_rearming
reearning1039053reearning
relearning1135283relearning
searing83330923_sear_ing
shearing123915903shear_ing
shearling1336923shearling
sleaving123310983slea_ving
slewing113311353sle__wing
smearing113511753smear_ing
spearing113216103spear_ing
swearing123711443swear_ing
tearing84021493_tear_ing
unlearning1144713unlearning
wearing113318863_wear_ing
wearying1546703_wearying
yearling1297883_yearling
yearning1296983_yearning

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 Filter1786911486410.420425454.8
2DLD Change Limit1486411306.54622707.1
3Display Results1301300.0462826.1
 (SQL Overall)1786911307.01225483.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.