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

274 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
resigned103886(None) 
designed1136941designed
reigned949211re_igned
resigner937791resigner
resined84522651resi_ned
assigned1044632assigned
cosigned1235722cosigned
deigned1037502de_igned
designee1087752designee
designer1036542designer
feigned1245352fe_igned
lesioned936902lesioned
realigned1145332realigned
reassigned1243602reassigned
redesigned1343372redesigned
refined114720002refi_ned
rehinged1336852rehinged
reined74425522re_i_ned
rejigged1833682rejigged
relined85321932reli_ned
renigged1135052renigged
repined104918772repi_ned
repinned1157472repinned
repugned1235362repugned
rerigged1136242rerigged
reshined123011122reshined
resided95217702resi_ded
resifted12310152resifted
resighted1436522resighted
resign74212582resign__
resignedly1552532resignedly
resigners1036862resigners
resigns83910962resign_s
resiled84621982resi_led
resisted9312692resisted
resited85122422resi_ted
resized174614902resi_zed
rosined84911902rosi_ned
signed83413752__signed
unsigned1037562unsigned
aligned9128553_aligned
arraigned11103033arraigned
assignee944843assignee
assigner944853assigner
basined10310003basi_ned
beigne9148613be_igne_
beignes10149243be_ignes
beignet101510963be_ignet
beringed1298173beringed
besieged1234733besieged
bewigged1643383bewigged
bewinged1584473bewinged
codesigned1542563codesigned
coigned11418663_coigned
consigned1346323consigned
cosigner1135953cosigner
defined123813823defi_ned
deraigned1244093deraigned
design8408933design__
designated1345933designated
designedly1652253designedly
designees1145003designees
designers1136003designers
designs9328313design_s
desired9311983desi_red
desisted1039783desisted
destined103312453destined
eloigned1043423eloigned
engined9119893_engined
ermined10410603ermi_ned
feigner1135593fe_igner
freshened1645253freshened
insigne837673insigne_
lessened935103lessened
lessoned945393lessoned
maligned1285773maligned
neighed12135893ne_ighed
peined94918843pe_i_ned
pensioned1246653pensioned
preassigned1552603preassigned
presaged1238803presag_ed
presided12410553presi_ded
presifted1536873presifted
presignal12105553presignal
presignaled1552383presignaled
rained75024603r_ai_ned
rationed9410093rationed
ravined115411823ravi_ned
reargued1035573reargued
reasoned9410733reasoned
rebilled11318053rebilled
rebind94416933rebi_n_d
recaned102817203re_caned
recited104319103reci_ted
reckoned1546953reckoned
reclined113613603reclined
recoined113614423recoined
reconned113610653reconned
reconsigned1553503reconsigned
reddened1136423reddened
redialed10310793redialed
redipped1434783redipped
redlined103811233redlined
redonned10297103redonned
reearned948883reearned
refigured1443933refigured
refiled114318653refi_led
refilled12278673refilled
refilmed14235813refilmed
refind104717073refi_n_d
refine95225693refi_ne_
refiner105316913refi_ner
refines105426343refi_nes
refired115116993refi_red
refitted12309413refitted
refixed183611153refi_xed
refuged125410873refug_ed
regained102111243regained
regilded1135543regilded
rehanged1357833rehanged
rehinge1148503rehinge_
rehinges1248403rehinges
rehired115013153rehi_red
reified112913783re_ified
reign65015193re_ign__
reignited1145683re_ignited
reigns74811753re_ign_s
reinked1239793re_inked
reissued944903reissued
reived104518133re_i_ved
rejigger1743183rejigger
rejoined16318593rejoined
relied74926233reli__ed
relieved12438513relieved
relighted1436863relighted
reline65434353reli_ne_
relines75331323reli_nes
relinked1337003relinked
relished1239433relished
relisted9312623relisted
relived115114683reli_ved
reloaned939723reloaned
remained112412893remained
remanned11319353remanned
remiges103015473remig_es
remind94819793remi_n_d
reminded123411523reminded
reminted113615083reminted
remised103516843remi_sed
remitted113312073remitted
remixed173510743remi_xed
reneged92010763reneg_ed
renowned1235983renowned
reoiled84316853reoi_led
reopened1138513reopened
repegged1334893repegged
repine85627813repi_ne_
repiner94816903repi_ner
repines94927383repi_nes
resailed93613063resailed
resawed113111183res_awed
rescaled113311303rescaled
rescind10410393rescin_d
rescinded1335763rescinded
rescored114513103rescored
rescued10410043res_cued
resealed92713973resealed
reseated93220263reseated
resected112514743resected
reseed74823293res__eed
reseeded1038093reseeded
reseized1839213reseized
resend75016773res_en_d
resented92716963resented
reserved121010583reserved
resewed113011823res_ewed
reshaped1437203reshaped
reshaved1536873reshaved
reshine102816943reshine_
reshines112615443reshines
reshingled1542783reshingled
reshipped1753893reshipped
reshoed112212153res_hoed
reshone102414163reshone_
reshowed15117063reshowed
resid64124093resi___d
reside74224933resi_de_
resident9313753resident
resider84615803resi_der
resides84523283resi_des
residue8689863residue_
residues9338813residues
resight11510643resig_ht
resights1246733resights
resigning1139463resigning
resile64627673resi_le_
resiles74026543resi_les
resilver11337503resilver
resin54131053resi_n__
resinated10413283resinated
resinoid946413resinoid
resins64528773resi_n_s
resiny94617363resi_n_y
resister8311653resister
resite64128453resi_te_
resites74027793resi_tes
resize154117723resi_ze_
resizes164216843resi_zes
reslated93517523reslated
resoaked1337943resoaked
resodded1136353resodded
resoled84119283res_oled
resolved12349343resolved
resorbed1138533resorbed
resorted9313493resorted
resound869263resoun_d
resounded1136323resounded
resowed113712253res_owed
respaced1338503respaced
respaded1238133respaded
respired1148993respired
respited11410813respited
respond1039113respon_d
responded1336513responded
restaged103011863restaged
restated93120183restated
rested74430783res__ted
restoked135710533restoked
restored96417193restored
restyled1236953restyled
resulted939713resulted
resumed10310623res_umed
resurged1038623resurged
retagged1136063retagged
retained93016093retained
retied75924983reti__ed
retiled84420513reti_led
retimed104714653reti_med
retine66237333reti_ne_
retines75134673reti_nes
retinted94414363retinted
retinued95210823retinued
retired84620143reti_red
retitled9339553retitled
retuned86613973re_tuned
returned9459133returned
revenged1337553revenged
reviewed1534823reviewed
reviled114417923revi_led
revised113815483revi_sed
revived144211653revi_ved
reweighed1742903reweighed
rewidened1444073rewidened
rewind104715883rewi_n_d
rewinded13277673rewinded
rewired115413283rewi_red
rexine134719443rexi_ne_
rexines144719153rexi_nes
rezoned173611163re_zoned
rigged94517403r__igged
ringed84623843r__inged
ruined74813323r_ui_ned
rusine63916593rusi_ne_
seined74023063se_i_ned
sighed113712053__sighed
signee73617233__signee
signer74015633__signer
signet73621153__signet
singed85422293__singed
sinned73818413__sinned
tensioned1045613tensioned
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.436409841.7
2DLD Change Limit1461622747.47019566.5
3Display Results2742740.1102490.9
 (SQL Overall)1786912748.01622291.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.