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

122 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
islanding113562(None) 
disbanding1545582disbanding
landing92819322__landing
relanding112110922relanding
sanding93520602_s_anding
slanging103413432_slanging
slanting94115092_slanting
standing103413632_standing
ascending1336283ascending
balancing1435783balancing
banding114921413__banding
belauding1335463belauding
blading113615363_bla_ding
blanking154411933_blanking
blending12249963_blending
blinding123210163_blinding
branding122513683_branding
celandine1245623celandine
cladding1337143_cladding
clanging124012123_clanging
clanking154313063_clanking
demanding14237923demanding
desanding12207653desanding
discanting1449453discanting
discarding1547343discarding
dispending1547923dispending
displanting1546043displanting
distancing1447083distancing
distending1348333distending
expanding2044793expanding
flanging132710583_flanging
flanking164211083_flanking
garlanding1344433garlanding
gladding1236303_gladding
glancing1247063_glancing
handing123518893__handing
husbanding1742943husbanding
illuding1035803i_lluding
impending1535933impending
implanting1545323implanting
incanting1289903incanting
inlacing1158373inla_cing
inlaying1247893inla_ying
inspanning1343203inspanning
instancing1344643instancing
intending1139983intending
invading1336263inva_ding
inwinding1445173inwinding
island738533island___
islanded1035513island_ed
islander946103island_er
islanders1035283islanders
islands837323island__s
isling71213883isl___ing
isolating1039743isola_ting
lading84227123__la_ding
lancing103314123__lancing
landings103110073__landings
larding92917873__larding
lauding93211903__lauding
lending94118533__lending
misadding14115833mis_adding
misbinding1645063misbinding
misbranding1744293misbranding
mishandling1843333mishandling
mislaying1557913misla_ying
misleading1446833misleading
misplanning1653873misplanning
misplanting1645633misplanting
missending1446493missending
mistending1447953mistending
planing103418253_plan_ing
planking153513013_planking
planning113610223_planning
planting113515383_planting
postlanding1543833postlanding
relending112412023relending
remanding132211143remanding
sandling102214413_s_andling
saning75127643_s_an_ing
scalding12339393_scalding
scanning113310773_scanning
scanting113914763_scanting
scending122610583_scending
sending94221373_s_ending
shading123115563_sha_ding
shanking163612283_shanking
shending132511253_shending
silencing1245053silencing
skanking12288743_skanking
slabbing13287783_slabbing
slacking153914133_slacking
slagging113711583_slagging
slaking123717473_sla_king
slamming133310003_slamming
slandering1237243_slandering
slapping133510843_slapping
slashing123713413_slashing
slating83724653_sla_ting
slatting94014233_slatting
slaving113514833_sla_ving
slaying113316843_sla_ying
sledding11248503_sledding
sliding93114553_sl_iding
slinging103312863_slinging
slinking133412983_slinking
sounding102712873_sounding
spading113114383_spa_ding
spanking153911973_spanking
spanning113311083_spanning
spending122712433_spending
standings11257153_standings
stanging104013653_stanging
staning83922243_stan_ing
stranding1149653stranding
swanking16399963_swanking
swanning12338813_swanning
swarding1359003_swarding
unhanding1437203unhanding
unlading1058863unla_ding
upstanding1443713upstanding
valancing1544743valancing

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.406440125.6
2DLD Change Limit1486411226.26623721.8
3Display Results1221220.0602033.3
 (SQL Overall)1786911226.73226543.5
 
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.