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

181 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
designed113694(None) 
deigned1037501de_igned
designee1087751designee
designer1036541designer
resigned1038861resigned
assigned1044632assigned
codesigned1542562codesigned
cosigned1235722cosigned
defined123813822defi_ned
deraigned1244092deraigned
design8408932design__
designated1345932designated
designedly1652252designedly
designees1145002designees
designers1136002designers
designs9328312design_s
desired9311982desi_red
desisted1039782desisted
destined103312452destined
feigned1245352fe_igned
lesioned936902lesioned
redesigned1343372redesigned
reigned949212re_igned
resigner937792resigner
resined84522652resi_ned
signed83413752__signed
unsigned1037562unsigned
aligned9128553_aligned
assignee944843assignee
assigner944853assigner
basined10310003basi_ned
beigne9148613be_igne_
beignes10149243be_ignes
beignet101510963be_ignet
beringed1298173beringed
besieged1234723besieged
bewigged1643383bewigged
bewinged1584473bewinged
coigned11418663_coigned
consigned1346323consigned
cosigner1135953cosigner
deaconed1237493deaconed
deadened1137233deadened
deafened1335853deafened
deaired9411533deai_red
deaned84620453de__aned
debagged1433723debagged
debited113311623debi_ted
deboned113411633de_boned
debugged1433223debugged
decerned1237263decerned
decided124312423deci_ded
decisioned1444143decisioned
declined123910883declined
deepened1235663deepened
defanged1435433defanged
defied115016383defi__ed
defiled124013103defi_led
define104718143defi_ne_
definer114413773defi_ner
defines114118683defi_nes
defogged1533783defogged
dehisced1583683dehisced
dehorned1345683dehorned
deiced104214483de_i_ced
deified123112413de_ified
deign74312803de_ign__
deigns8389983de_ign_s
delighted1546203delighted
delimed11310723deli_med
delisted10310563delisted
deluged10167413delug_ed
demeaned1237283demeaned
demigod1254193demig_od
demised113613683demi_sed
demitted12288773demitted
denied84318633deni__ed
denimed1159233deni_med
denizened2042753denizened
denned84215633de__nned
densified1446713densified
depicted1437743depicted
deplaned1238663deplaned
deponed113712873de_poned
deranged1137693deranged
derided102914253deri_ded
deringer1038143deringer
derived123912763deri_ved
desalted1038313desalted
desand84812633des_an_d
desanded11227453desanded
descanted1336673descanted
descend11248153descen_d
descended1446283descended
descried1248073descried
deserted101012203deserted
deserved13108133deserved
desexed1636183des_exed
designate1147113designate
designates1246363designates
designing1236623designing
designment1446053designment
desilver12286503desilver
desinent9312963desi_nent
desire7415303desi_re_
desirer8310783desi_rer
desires81316133desi_res
desorbed1236443desorbed
despised1236923despised
despited1248323despited
despond1137513despon_d
desponded1445323desponded
destained1158253destained
destine83719953destine_
destines93619663destines
desugared1242663desugared
detained103111643detained
deticked1635693deticked
deveined1336673deveined
deviated13311043deviated
deviled124112183devi_led
devilled1336743devilled
devised123712563devi_sed
dezinced2183903dezinced
digged104314653d__igged
dined76431993d__i_ned
dinged95221783d__inged
dinned84317613d__inned
dislimned1344623dislimned
disowned1336433disowned
divined12329693divi_ned
drained93713253drai_ned
dwined114610213d_wi_ned
eloigned1043423eloigned
engined9119893_engined
feigner1135593fe_igner
insigne837673insigne_
lessened935093lessened
lessoned945393lessoned
maligned1285773maligned
neighed12135893ne_ighed
outdesigned1451493outdesigned
peined94918843pe_i_ned
pensioned1246653pensioned
realigned1145333realigned
reassigned1243603reassigned
refined114720003refi_ned
rehinged1336853rehinged
reined74425523re_i_ned
rejigged1833683rejigged
relined85321933reli_ned
renigged1135053renigged
repined104918773repi_ned
repinned1157473repinned
repugned1235363repugned
rerigged1136243rerigged
reshined123011123reshined
resided95217703resi_ded
resifted12310153resifted
resighted1436523resighted
resign74212583resign__
resignedly1552533resignedly
resigners1036863resigners
resigns83910963resign_s
resiled84621983resi_led
resisted9312693resisted
resited85122423resi_ted
resized174614903resi_zed
rosined84911903rosi_ned
seined74023063se_i_ned
sighed113712053__sighed
signee73617233__signee
signer74015633__signer
signet73621153__signet
singed85422293__singed
sinned73818413__sinned
tensioned1045613tensioned
undersigned14114973undersigned
veined104413913ve_i_ned
visioned1247013visioned
weighed15135933we_ighed

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.420425454.8
2DLD Change Limit1461621818.09318060.3
3Display Results1811810.1401292.9
 (SQL Overall)1786911818.65320650.8
 
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.