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

174 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
expand1623657(None) 
expands17195731expands
expend16247501expend
eland65820392e_land
errand758792errand
expanded19145162expanded
expander18145802expander
expandor18142762expandor
expanse16145602expanse
expat14313812expa_t
expats1537682expats
expends17217082expends
explant16310132explant
expound1744372expound
extant132714752extant
extend14267522extend
repand95316062repand
aland65526413_aland
and47244173___and
append1138273append
axman144813183axman_
band76740913__band
bedpan1137583bedpan_
bedpans1237173bedpans
bland85320453_bland
brand85124493_brand
demand104314253demand
deodand1035713deodand
depend103510923depend
desand84812633desand
despond1137513despond
dopant9316133dopant
echard1249223echard
egad64215413e_ga_d
elan46734243e_lan_
elands74914773e_lands
elans55527753e_lans
elapid939543elapid
eluant6315093eluant
embank14346553embank
emend86214893e_mend
empale102611263empale
empaled12288953empaled
empanada1341883empanada
empanel1145963empanel
emplane11410013emplane
emplaned1337163emplaned
end46834353e___nd
enplane939723enplane
enplaned1137483enplaned
enwind10298083enwind
epact94921533e_pact
ephod1139123e_phod
errands847603errands
errant6618733errant
espanol943783espanol
espied9359773espied
ethane94613243ethane
exact143516933ex_act
exalt123018533ex_alt
exam132514623ex_a_m
exams14199083ex_ams
exapted1736073exapted
exceed1636173exceed
exed125420593ex__ed
exeunt1338703exeunt
exhale1636873exhale
exhaled1835283exhaled
exiled144712463exiled
exine125518493ex_ine
exing136016813ex_ing
exited144712523exited
exon117116803ex_on_
exons125813343ex_ons
expanders19125093expanders
expanding2044793expanding
expandors19142833expandors
expanses17156173expanses
expect1758903expect
expel1448233exp_el
expels1547173expels
expended19136543expended
expender18136843expender
expense16127873expense
expensed18126413expensed
expert15515353expert
expiate16910593expiate
expiated18168523expiated
expire1538023expire
expired1736403expired
expiry1834653expiry
explain1667043explain
explained1944543explained
explains1766443explains
explanted1944973explanted
explants1737023explants
explode1745963explode
expo1349183exp__o
export15412183export
expos1449203exp_os
expose1549523expose
exposed1737443exposed
expounds1843233expounds
expunge1743313expunge
expunged1942973expunged
exscind1743753exscind
extends15227113extends
extent132714913extent
exuded15317683exuded
fenland1135693fenland
gland75217713_gland
grand75122693_grand
hand86833713__hand
hexad164910623hex_a_d
hexane16379533hex_ane
hexapod2043653hexapod
impend11478793impend
inland7310313inland
island738533island
japan14411233japan_
japans1539823japans
jeopard1744113jeopard
keypad1633823keypa_d
land56337313__land
leopard1045293leopard
ligand85011293ligand
pad68057323__pa_d
paid75737483__paid
pan58466453__pan_
panda85022613__panda
pandy115021173__pandy
pane64950293__pane
paned85437183__paned
pang75336293__pang
pans65855733__pans
pant66061263__pant
pard76441323__pard
pend75934533__pend
perpend12259353perpend
pond75530493__pond
rand55839573__rand
reland75920433reland
remand95618963remand
repaid94716323repaid
respond1039113respond
riband9239623riband
roband92310723roband
sand55338473__sand
sextan13389643sextan_
sextans14349263sextans
sextant142911963sextant
soland75115043soland
spaed85522273_spaed
span65234663_span_
spang84919733_spang
spank115919573_spank
spans74528733_spans
spend85619333_spend
stand65923283_stand
strand74514823strand
taxpaid1743093taxpaid
teopan839353teopan_
teopans939203teopans
ulpan7310123ulpan_
unhand10410383unhand
unpaid939473unpaid
upend85011043_upend
upland938863upland
viand9511073_viand
wand85833883__wand
weasand1135503weasand
weazand2043613weazand
wessand1144833wessand
wetland1135353wetland

Search took 6 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 Filter1786911127160.376475242.0
2DLD Change Limit1127161744.79623502.1
3Display Results1741740.0463782.6
 (SQL Overall)1786911745.21834245.1
 
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.