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

176 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
wrestling133606(None) 
wrastling1335521wrastling
wresting123811831wrest_ing
wrestlings1442931wrestlings
bristling1246662bristling
cresting114017042crest_ing
nestling958892_nestling
pestling111010252_pestling
resiling93520172_resiling
resoling92916302_resoling
resting85031182_rest_ing
restring91518782_restring
restyling1337922_restyling
rustling9249982_rustling
warstling1335062warstling
westing115020272w_est_ing
whistling1644732whistling
wrassling1334272wrassling
wreathing16266312wreathing
arresting1038633arrest_ing
beetling1139283_beetling
besting104923923_best_ing
brattling1236003brattling
breasting1239583breast_ing
breathing15218373breathing
brisling112410843bris_ling
brittling1235543brittling
bustling112110063_bustling
castling11311233_castling
creating113921953creat_ing
creeling113513363cre_eling
creneling1247733creneling
crestings12298043crest_ings
crusting113612793crust_ing
dieseling1146143dieseling
dressing102810423dres_sing
egesting1039013egest_ing
erecting112415063erect_ing
fettling1266773_fettling
firstling1334423firstling
foresting13311363forest_ing
freckling1934703freckling
frescoing1544683frescoing
freshing152611023fres_hing
fretting122711523fre_tting
frosting12311183frost_ing
frostline1245883frostline
gentling1048453_gentling
greenling1136753greenling
greeting103112353greet_ing
gruntling1134263gruntling
guesting1058463guest_ing
hustling12228793_hustling
jesting154317713_jest_ing
jostling16207123_jostling
justling16207253_justling
nesting84320443_nest_ing
nestlings1074313_nestlings
nettling957213_nettling
outwrestling1651693outwrestling
pettling1168213_pettling
prattling1246303prattling
prefiling1549533prefiling
presaging1339393presaging
preselling1338693preselling
presetting131010833presetting
presettling1444453presettling
presiding13510903presiding
presolving1644363presolving
pressing112516443pres_sing
prestoring13310303prestoring
presuming1437663presuming
prettying1536043prettying
priesting1239483priest_ing
questing1838273quest_ing
rassling939013_rassling
rattling92510873_rattling
reddling112911813_reddling
reedling102414273_reedling
reeling83126863_re_eling
reesting93118273reest_ing
refiling123116533_refiling
regaling10315363_regaling
renting84026853_rent_ing
reoiling93217213_reoiling
resailing103314253_resailing
resawing122311433_resawing
resaying122512453_resaying
rescaling122212013_rescaling
rescuing1139623_rescuing
resealing102115673_resealing
reseeing92412623_reseeing
reselling102213833_reselling
resetting102816293_resetting
resettling1135893_resettling
resewing122712263_resewing
residing103015473_residing
resilin72913973_resilin_
resilins83013373_resilins
resining92919553_resining
resiting93521123_resiting
resitting103414873_resitting
resizing182714163_resizing
resolving1337743_resolving
resowing123111523_resowing
respring111614063_respring
restabling1337653_restabling
restaging112410853_restaging
restating102319413_restating
restoking1438193_restoking
restoring10314613_restoring
restrings10159293_restrings
restrung9176443_restrung
resulting10311083_resulting
resuming11310083_resuming
retiling93319483_retiling
retitling1039773_retitling
retting83425883_re_tting
retying113213833_re_tying
reveling123117083_reveling
reviling122917213_reviling
riesling939013ries_ling
rootling9269953_rootling
rusting83821263_rust_ing
settling978943_settling
testing86021053_test_ing
treadling1137503treadling
treating92519613treat_ing
trebling1139873tre_bling
treddling1234423treddling
trembling1435193trembling
trusting93411653trust_ing
trysting12267053tryst_ing
unresting10311133unrest_ing
vesting114618683_vest_ing
waisting123615213waist_ing
waistline1244173waistline
warsling12198593wars_ling
wasting114422843w_ast_ing
wattling12258783w_attling
weakling16106763w_eakling
weanling12118643w_eanling
weaseling1335613weaseling
wedeling1338773w_edeling
weeting113816053w_eet_ing
welling112920313w_e_lling
welting113615313w_elt_ing
westering132112643w_estering
westings12429803w_est_ings
wetting114117383w_e_tting
wheedling1733073wheedling
wheeling15318593whe_eling
wheepling1843323wheepling
whetting1535973whe_tting
whisting15329543whist_ing
whistlings1742913whistlings
whittling1634383whittling
wintling12249923w_intling
wisting113519743w_ist_ing
witling113215813w__itling
worsting1267683worst_ing
wrangling1456223wrangling
wrathing15248923wr_athing
wreaking163010213wre_aking
wrecking18328153wre_cking
wrenching18276273wrenching
wrestle10298843wrestl__e
wrestled12296763wrestl_ed
wrestler11306993wrestl_er
wrestlers12306103wrestlers
wrestles113310063wrestl_es
wriggling1533813wriggling
wrinkling17144953wrinkling
writhing15278673wr_ithing
writing113713893wr_it_ing
zesting174515333_zest_ing

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 Filter1786911486410.420425454.8
2DLD Change Limit1486411766.40623203.4
3Display Results1761760.0802200.0
 (SQL Overall)1786911766.90625874.7
 
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.