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

221 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
solander94812(None) 
colander1139031colander
slander84015441s_lander
solanders1036961solanders
bilander1136672bilander
blander103715162_blander
colanders1238012colanders
inlander937222inlander
islander946102islander
lander74028482__lander
lowlander1342992lowlander
oleander936402_oleander
pomander1347082pomander
sander74828532s__ander
slanders94014012s_landers
slender83413592s_lender
solacer93011102sola_cer
soland75115042soland__
solands84412342soland_s
solder73921342sol__der
solider82912452sol_ider
sonder73623522so__nder
sounder83315382so_under
squander1835532squander
stander84316162s_tander
strander97112052strander
uplander1145532uplander
auslander1043883auslander
balancer1246603balancer
bander93928223__bander
bilanders1235963bilanders
bladder11429153_bladder
blader93618583_bla_der
blanker134612023_blanker
blender104613843_blender
blinder103912983_blinder
blonder104011943_blonder
blunder103813143_blunder
boarder103910323bo_arder
bolder94820933bol__der
bonder95324783bo__nder
bounder104215533bo_under
brander103915823_brander
calender1138273calender
clanger104113493_clanger
colder95121833col__der
coleader1139173coleader
collider113410413collider
colluder11276863colluder
commander16127403commander
coriander1245653coriander
cylinder1433383cylinder
dander811222993__dander
demander12238723demander
expander18145803expander
flanger113412623_flanger
flanker143911293_flanker
flinder11319873_flinder
flounder1235103flounder
folder104317543fol__der
fonder104120063fo__nder
founder114312563fo_under
gander84322763__gander
gladder10398313_gladder
glancer103710073_glancer
glanders103811503_glanders
glandes95413833_glandes
golder84417603gol__der
goosander1143253goosander
grander93315873_grander
hander104526433__hander
hoarder11329233ho_arder
holder104619653hol__der
hounder113412233ho_under
inlanders1036133inlanders
islanded1035513islanded
islanders1035283islanders
joinder15337593jo_inder
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
loader74316303lo_a_der
loaner64416503lo_an_er
lowlanders1442693lowlanders
malanders1237023malanders
meander1049973_meander
moaner84415113mo_an_er
molder93819273mol__der
older65121173_ol__der
oleanders1035573_oleanders
outlander1045733outlander
pander93725523__pander
philander1544063philander
planer84122653_plan_er
planner93511623_planner
planter94017803_planter
plunder103810493_plunder
polder94019253pol__der
pomanders1436223pomanders
ponder94521693po__nder
pounder103313993po_under
relanded102410463relanded
relaunder1053703relaunder
romancer1247293romancer
rounder83514593ro_under
sadder82916973s__adder
salamander1352863salamander
sanded84920613s__anded
sanders84025943s__anders
sandier84017843s__andier
saner54334323s__an_er
sanger74524563s__anger
scanner94411813s_canner
scanter94215183s_canter
sclaffer16112653sclaffer
scolder103210333scol__der
seconder1137183seconder
sender73824413s__ender
shader104218763s_ha_der
silane62718053silan_e_
silanes72517163silan_es
silencer1036293silencer
silenter838873silenter
skanker10268483s_kanker
slabber113311393s_labber
slacker133915293s_lacker
slaker104219273s_la_ker
slammer113913033s_lammer
slandered1137473s_landered
slanderer1046673s_landerer
slanged94112853s_langed
slangier9117933s_langier
slanted83514743s_lanted
slapper113512463s_lapper
slasher104515323s_lasher
slater64429183s_la_ter
slather103816063s_lather
slatier74016813s_latier
slaver94419613s_la_ver
slayer93916333s_la_yer
sledder9399203s_ledder
slider73918363s_l_ider
slinger83413833s_linger
sloganeer1042373sloganeer
smolder10327753smol__der
soaker105717533so_a_ker
soaper84517873so_a_per
soapier93411713so_apier
soarer64522243so_a_rer
socager10107703soca_ger
solace83415823sola_ce_
solaced102911063sola_ced
solacers10268893sola_cers
solaces93116133sola_ces
solan55328153solan___
solanin7311943solan_in
solanine8311533solanine
solanines9310083solanines
solanins8310513solanins
solano65314183solan__o
solanos74412853solan_os
solans64122493solan__s
solanum946403solan_um
solanums1044433solanums
solar55927343sola___r
solate64526073sola_te_
solated83618023sola_ted
solates73523853sola_tes
solderer947183solderer
solders83517773sol__ders
soldier82812153sol_dier
solemner1045053solemner
solunar735283solun_ar
solver94016703sol__ver
sonance9310313sonance_
sonances10310263sonances
sonde64622833so__nde_
sonders83820713so__nders
sondes74922873so__ndes
sooner64220463so_on_er
sorner64720383so_rn_er
sounded93214463so_unded
sounders93214103so_unders
spader94317133s_pa_der
spandex1735833s_pandex
spanker133612353s_panker
spanner94312563s_panner
spender103713693s_pender
splasher1335653splasher
splatter10348883splatter
splendor1143743splendor
splinter10329703splinter
squanders1934443squanders
staider83912613s_taider
standee83514513s_tandee
standers93514303s_tanders
stolider936603stol_ider
stranded102710813stranded
stranders10389923stranders
stranger94715093stranger
sunder74019823s__under
swanker14369483s_wanker
tolane64316583tolan_e_
tolanes74216313tolan_es
uitlander1042963uitlander
uplanders1234853uplanders
volante1038513volante_
wander104423713__wander
wonder103617813wo__nder
woodlander1552433woodlander
yonder103214133yo__nder
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.1731032896.0
2DLD Change Limit1461622217.79618748.3
3Display Results2212210.0762907.9
 (SQL Overall)1786912218.04522211.4
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.