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

151 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
islander94610(None) 
inlander937221inlander
islanded1035511islanded
islanders1035281islanders
slander84015441_slander
auslander1043882auslander
bilander1136672bilander
blander103715162_blander
colander1139032colander
inlanders1036142inlanders
island738532island__
islands837322island_s
lander74028482__lander
sander74828532_s_ander
slanders94014012_slanders
slender83413592_slender
solander948122solander
stander84316162_stander
uitlander1042962uitlander
uplander1145532uplander
ascender1136733ascender
asunder856223as_under
auslanders1143363auslanders
balancer1246603balancer
bander93928223__bander
bilanders1235963bilanders
bladder11429153_bladder
blader93618583_bla_der
blanker134612023_blanker
blender104613843_blender
blinder103912983_blinder
blonder104011943_blonder
blunder103813153_blunder
brander103915823_brander
bystander1542593bystander
calender1138273calender
clanger104113493_clanger
colanders1238013colanders
cylinder1433383cylinder
dander811222993__dander
demander12238723demander
disbanded1445643disbanded
discarder1346753discarder
distender11167743distender
expander18145803expander
flanger113412623_flanger
flanker143911293_flanker
flinder11319873_flinder
gander84322763__gander
gladder10398313_gladder
glancer103710073_glancer
glanders103811503_glanders
glandes95413833_glandes
grander93315873_grander
hander104526433__hander
highlander1852563highlander
husbander1563153husbander
implanter1385363implanter
inaner62213543i_nan_er
inland7310313inland__
inlands838783inland_s
inlayer1036933inla_yer
insaner7310443insan_er
instanter946243instanter
intender93310443intender
invader11146453inva_der
islanding1135623islanding
ladder84617623__ladder
lader65633723__la_der
lancer84319973__lancer
landed84619243__landed
landers84026213__landers
landler84113203__landler
lanker104123003__lanker
lanner64920603__lanner
larder73720973__larder
lauder73815013__lauder
launder8309143__launder
lender73921273__lender
lowlander1342993lowlander
mainlander1352973mainlander
malanders1237023malanders
meander1049973_meander
mishanter1446453mishanter
mislayer1337503misla_yer
misleader1246503misleader
misrender1286293misrender
oleander936403oleander
outlander1045733outlander
pander93725523__pander
philander1544063philander
planer84122653_plan_er
planner93511623_planner
planter94017803_planter
plunder103810503_plunder
pomander1347083pomander
relanded102410463relanded
relaunder1053703relaunder
sadder82916973_s_adder
sanded84920613_s_anded
sanders84025943_s_anders
sandier84017843_s_andier
saner54334323_s_an_er
sanger74524563_s_anger
scanner94411813_scanner
scanter94215183_scanter
sender73824413_s_ender
shader104218763_sha_der
silane62718053silan_e_
silanes72517163silan_es
silencer1036293silencer
silenter838873silenter
skanker10268483_skanker
slabber113311393_slabber
slacker133915293_slacker
slaker104219273_sla_ker
slammer113913033_slammer
slandered1137473_slandered
slanderer1046673_slanderer
slanged94112853_slanged
slangier9117933_slangier
slanted83514743_slanted
slapper113512463_slapper
slasher104515333_slasher
slater64429183_sla_ter
slather103816073_slather
slatier74016813_slatier
slaver94419613_sla_ver
slayer93916333_sla_yer
sledder9399203_sledder
slider73918363_sl_ider
slinger83413833_slinger
solanders1036963solanders
sonder73623523_s_onder
sounder83315383_sounder
spader94317133_spa_der
spandex1735833_spandex
spanker133612353_spanker
spanner94312563_spanner
spender103713693_spender
squander1835533squander
staider83912613_staider
standee83514513_standee
standers93514303_standers
strander97112063strander
sunder74019823_s_under
swanker14369483_swanker
uitlanders1142833uitlanders
uplanders1234853uplanders
wander104423713__wander
zander163417113__zander

Search took 9 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.423422437.4
2DLD Change Limit1461621518.08018089.4
3Display Results1511510.1231227.6
 (SQL Overall)1786911518.62620715.4
 
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.