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

419 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
resigns8391096(None) 
designs9328311designs
reigns74811751re_igns
resign74212581resign_
resins64528771resi_ns
assigns836192assigns
cosigns1047512cosigns
deigns8389982de_igns
design8408932design_
ensigns836352ensigns
feigns10407752fe_igns
lesions73813862lesions
reagins84215642reagins
realigns936252realigns
reassigns1074352reassigns
redesigns1144072redesigns
regions83613472regions
reign65015192re_ign_
reins56234562re_i_ns
rejigs14368092rejig_s
remiges103015472remiges
renigs74314592renig_s
renins64526452reni_ns
repins84924312repi_ns
repugns1035392repugns
rerigs74014792rerig_s
resides84523282resides
resids74219152resi_ds
resifts10378702resifts
resight11510642resight
resights1246732resights
resigned1038862resigned
resigner937792resigner
resigners1036862resigners
resiles74026542resiles
resilins83013372resilins
resin54131052resi_n_
resiny94617362resi_ny
resists74414922resists
resites74027792resites
resits64725562resi_ts
resizes164216842resizes
rewins95020822rewi_ns
risings83211892risings
rosins64521862rosi_ns
signs65516322__signs
aligns75312953_aligns
arraigns944343arraigns
assign736783assign_
basins85722763basi_ns
basions94213953basions
begins94415303begi_ns
beiges91014403be_iges
beigne9148613be_igne
beignes10149243be_ignes
beings94613033be_ings
benign938313benign_
besides104814533besides
besieges1146003besieges
bewigs1246533bewig_s
brewings14296693brewings
busings103711223busings
casings104013513casings
cesiums1136303cesiums
cessions1039853cessions
codesigns1353663codesigns
coigns94410063_coigns
consigns1137533consigns
coreigns1136313core_igns
cosign958783cosign_
crestings12298043crestings
cretins93216423creti_ns
deign74312803de_ign_
deraigns1034873deraigns
designed1136943designed
designee1087753designee
designees1145003designees
designer1036543designer
designers1136003designers
desires81316133desires
desists83611723desists
desmans1039003desmans
dressings11265373dressings
eloigns8425353eloigns
ensign737523ensign_
eosins64419163eosi_ns
epigons1048183_epigons
erasions8310983erasions
erepsins1037443erepsi_ns
erosions8310333erosions
etesians845473etesians
feign94210713fe_ign_
freshens14298313freshens
fusions1039153fusions
greiges937733gre_iges
greisens954653greisens
hemins113417563hemi_ns
hessians1145053hessians
insigne837673insigne
jestings16368023jestings
leasings9379833leasings
leggins9259473leggins
legions84611783legions
lesbians1043603lesbians
lesion64715063lesion_
lessens7409383lessens
lessons73811013lessons
levins94514653levi_ns
losings82810623losings
lysins94610953lysi_ns
maligns1038133maligns
medians103214213medians
mesian84315503mesian_
mesons83215843mes_ons
messans92710463messans
musings10389543musings
nasions73112383nasions
neighs10387733ne_ighs
nosings8349593nosings
opsins8411713opsi_ns
peins76128063pe_i_ns
pekins121812233peki_ns
pensions10311693pensions
pepsins11310433pepsi_ns
perigons11310083perigons
preassigns1343553preassigns
presages11312203presages
presides11414913presides
presifts1366593presifts
presignal12105553presignal
presignals1363843presignals
pressings12269023pressings
prestiges12310593prestiges
racings105015123racings
radians83013823radians
rains55140233r_ai_ns
raisings9338443raisings
raisins72715343raisins
rasing74330833rasi_ng
raspings11337853raspings
ratings84217403ratings
rations74123433rations
ravings114614493ravings
ravins94622563ravi_ns
rawins95617623rawi_ns
readings103512633readings
reagin74915533reagin_
realign838763realign_
reasons72514943reasons
reassign955423reassign_
rebegins1136003rebegins
rebids94015523rebi_ds
rebills93510623rebills
rebind94416923rebi_nd
rebinds104511873rebinds
recipes113314463recipes
recisions1139913recisions
recites93524583recites
recits83621353reci_ts
reckons13269653reckons
recoins94019243recoins
recons84922993re_cons
reconsigns1344413reconsigns
redans75421023re_dans
reddens9259783reddens
redesign1045073redesign_
redfins1139923redfins
redials84416883redials
redias74523603redi_as
redigest1039733redigest
reding83825563redi_ng
redips93713843redi_ps
redons75222183re_dons
redskins1385873redskins
redwings13305733redwings
reearns749103reearns
reedings103510363reedings
reelings94012563reelings
refight1488873refight
refights1555883refights
refiles104122423refiles
refills103711423refills
refilms12347503refilms
refind104717073refi_nd
refinds114512123refinds
refine95225693refi_ne
refines105426343refines
refires104820313refires
refits94017653refi_ts
refixes174813173refixes
refuges115413373refuges
regains84316583regains
reges65628783re__ges
regilds996673regilds
regimens11469233regimens
regimes104514743regimes
regina75317143regi_na
reginas85614063reginas
region74614903region_
regius7311923regi_us
regives115014213regives
regna64614813re__gna
regs55436573re__g_s
rehangs1137563rehangs
rehinge1148503rehinge
rehinges1248403rehinges
rehires105016113rehires
reifs84819093re_i_fs
reigned949213re_igned
rein46040893re_i_n_
reink95518093re_i_nk
reinks105012153re_inks
reis45343233re_i__s
reives95723043re_ives
rejig133810123rejig__
rejoins143111383rejoins
reliant7319243reliant
relics84517903reli_cs
relicts94414593relicts
reliefs10439433reliefs
reliers75519213reliers
relies65036423reli_es
relight11512063relight
relights1248053relights
religions1086603religions
reline65434353reli_ne
relines75331323relines
relink104415923reli_nk
relinks114510223relinks
relists73817053relists
relives104619443relives
reloans7313133reloans
remains94117893remains
remans84823003re_mans
remind94819793remi_nd
reminds104614793reminds
remint85329973remi_nt
remints95117293remints
remises93423483remises
remiss84216353remi_ss
remits85622943remi_ts
remixes164313873remixes
reneges82513593reneges
renig64518913renig__
renin54830033reni_n_
rennins74013413rennins
renowns10277833renowns
reoils64516873reoi_ls
reopens939373reopens
repegs93311943repeg_s
repin75324703repi_n_
repine85627813repi_ne
repines94927383repines
replans92814943replans
repugn946493repugn_
requins16310203requins
rerig64018483rerig__
rerises73525883rerises
reruns66413743re_runs
resails74616743resails
resales74724903resales
resawn9399953resawn_
resaws93713513res_aws
resays93714153res_ays
rescind10410393rescind
rescinds1136333rescinds
rescues9312753rescues
reseals73917663reseals
reseats74319583reseats
reseaus74012153reseaus
resects94115593resects
resedas839123resedas
reseeds84012333reseeds
reseeks11348623reseeks
reseen64318413reseen_
resees63827483res_ees
reseizes1759853reseizes
resells73313203resells
resend75016773res_end
resends83513713resends
resent63833623res_ent
resents74221223resents
resets65427613res_ets
resewn9459813resewn_
resews94814173res_ews
reshes94124363res_hes
reshine102816943reshine
reshines112615443reshines
reships1239863reships
reshoes102316033reshoes
reshone102414163reshone
reshows132510453reshows
resid64124093resi__d
reside74224933resi_de
resided95217703resided
resident9313753resident
residents1038423residents
resider84615803resider
residers93311883residers
residing103015473residing
residua8286623residua
residue8689863residue
residues9338813residues
resift94017723resi_ft
resigning1139463resigning
resile64627673resi_le
resiled84621983resiled
resilin72913973resilin
resiling93520173resiling
resined84522653resined
resining92919553resining
resinous838503resinous
resist64524533resi_st
resit54241043resi__t
resite64128453resi_te
resited85122423resited
resiting93521123resiting
resize154117723resi_ze
resized174614903resized
resizing182714163resizing
resoaks1148973resoaks
resods74116303res_ods
resoles73823653resoles
resorbs95010523resorbs
resorts74817193resorts
resound869263resound
resounds956483resounds
resown94112923resown_
resows93915353res_ows
respires10311903respires
respites10513243respites
respond1039113respond
responds1136913responds
responsa1043573responsa
response1037743response
respots92912763respots
resprings12156253resprings
restages92815763restages
resters74130403resters
resting85031183resting
restrings10159293restrings
rests54935873res__ts
results739833results
resumes9313373resumes
resurges9310123resurges
retags73414303retag_s
retains74522253retains
reties65436193reti_es
retiles74426993retiles
retimes95020173retimes
retina65023383reti_na
retinas74819353retinas
retine66237333reti_ne
retines75134673retines
retint65633443reti_nt
retints74717013retints
retires74726213retires
retsina74710603retsi_na
retsinas8387963retsinas
returns79712593returns
reunions837273reunions
reusing82516783reusi_ng
reviews1335533reviews
reviles104421353reviles
revises104220533revises
revisions1238593revisions
revives134715543revives
reweighs1583203reweighs
rewidens1235533rewidens
rewin85623963rewi_n_
rewind104715883rewi_nd
rewinds114810483rewinds
rewires104717113rewires
rexine134719443rexi_ne
rexines144719153rexines
ricins83618703rici_ns
ridings93412083ridings
rieslings1034493rieslings
rigs55137593r__ig_s
rings65029173r__ings
rins46153193r__i_ns
rinsings9318013rinsings
rising74025883risi_ng
robins83617443robi_ns
ronions73313343ronions
rosin55325313rosi_n_
rosing73925593rosi_ng
rosiny94414533rosi_ny
rovings11439493rovings
rowings113710363rowings
rubigos1033643rubigos
ruins55822033r_ui_ns
rulings83310383rulings
rushings12387843rushings
rusine63916593rusi_ne
rutins63818393ruti_ns
sasins64923103sasi_ns
seeings84411293seeings
seisings9398523seisings
seisins73614393seisins
serins64029673seri_ns
sessions839713sessions
sewings11369173sewings
sighs95416743__sighs
sign55523053__sign_
signa66114703__signa
sings65532703__sings
sins46755273__si_ns
tensions8310223tensions
testons7313553testons
veins84620493ve_i_ns
venins93816703veni_ns
versions11310353versions
vestiges1238243vestiges
vestings12359143vestings
visions10311023visions
weighs13338873we_ighs
westings12429803westings
zeins144715393ze_i_ns

Search took 8 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 Filter1786911340270.1401276364.3
2DLD Change Limit1340274197.11018850.5
3Display Results4194190.1562685.9
 (SQL Overall)1786914197.40624127.9
 
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.