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

212 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
assigns83619(None) 
assign736781assign_
aligns75312952a_ligns
askings12519172askings
assignat945682assignat
assignats1044002assignats
assigned1044632assigned
assignee944842assignee
assignees1043502assignees
assigner944852assigner
assigners1044412assigners
assignor942992assignor
assignors1043242assignors
assists738472assists
assizes1638452assizes
cosigns1047512cosigns
designs9328312designs
ensigns836352ensigns
gassings10438402gassings
passings11409872passings
passions10310582passions
reassigns1074352reassigns
resigns83910962resigns
sasins64923102sasi_ns
signs65516322__signs
ablings1038743ablings
ablins8316193abli_ns
actings104512463actings
actins86321103acti_ns
actions94218513actions
ageings9437693ageings
agings86312673a_gings
ains46158883a__i_ns
airings83913843airings
airns55521033a__irns
algins74816433algi_ns
aliens65619213a_liens
align65016503a_lign_
aloins65022203aloi_ns
alsikes1137263alsikes
amigas95912173a_migas
amigos94511213a_migos
amins75534323a_mi_ns
amnions93710913amnions
anions64123033a_nions
antigens9310603antigens
antings85015583antings
apsides103911303apsides
apsis75718293apsi__s
armings103811503armings
arraigns944353arraigns
arshins10312573arshins
arsine64021043arsi_ne
arsines73518813arsines
arsino64113513arsi_no
arsis55722423arsi__s
arsons63917213ars_ons
ascites9312603ascites
asdics9439863asdi_cs
ashcans1235183ashcans
ashing107824093ashi_ng
asides75118873a_sides
asking116017233aski_ng
aspens85013353a_spens
aspics104211563aspi_cs
aspires9612043aspires
aspirins1037733aspirins
aspis74618143aspi__s
aspises9611643aspises
assagai843903assagai
assagais943813assagais
assails769093assails
assais6711963ass_ais
assays977903ass_ays
assegai843353assegai
assegais943953assegais
assent65119953ass_ent
assents74512223assents
asserts74311793asserts
asses55629283ass__es
assess65710463ass_ess
assets65617663ass_ets
assigning1144673assigning
assist6314603assi_st
assize1538633assi_ze
assoils776663assoils
assorts73310153assorts
assuages936273assuages
assumes967163assumes
assures7611403assures
asswages1255053asswages
audings9289393audings
auxins13129813auxi_ns
avians93711563a_vians
avions94114393a_vions
awnings11406713awnings
axions134713483a_xions
ayins85321613a_yi_ns
bashings144311243bashings
basins85722763basi_ns
basions94213953basions
bassists1037183bassists
bassoons1036553bassoons
bastings114214693bastings
bastions10411693bastions
busings103711223busings
bussings11386663bussings
caseins93115053casei_ns
casings104013513casings
cassias93514343cassi_as
cassina94113163cassi_na
cassinas103610633cassinas
cassine93817283cassi_ne
cassines103116613cassines
cassino93512433cassi_no
cassinos10309353cassinos
cassis84818853cassi__s
cassises103811743cassises
castings113614053castings
cessions1039853cessions
coigns94410063_coigns
consigns1137533consigns
cosign958783cosign_
dassies84418663dassi_es
deigns8389983_deigns
design8408933design_
eastings93412953eastings
eloigns8425353eloigns
ensign737523ensign_
eosins64419163eosi_ns
essoins737603essoins
fashions1437243fashions
fastings124011943fastings
feigns10407753_feigns
fissions1138033fissions
fusions1039153fusions
gaskings14427473gaskings
gaskins123510773gaski_ns
gassing94216333gassi_ng
hassiums1344273hassiums
hessians1145053hessians
hissings12556753hissings
insigne837673insigne
jasmins1637083jasmi_ns
jassids1586143jassi_ds
kamsins1346963kamsi_ns
lashings124412253lashings
lashins103915153lashi_ns
lassies74420103lassi_es
lassis65216703lassi__s
lastings94214423lastings
lesions73813873lesions
losings82810623losings
lysins94610953lysi_ns
maligns1038133maligns
mansions1069793mansions
maskings15448753maskings
massages1159883massages
massifs1237743massi_fs
massing104318023massi_ng
misassigns1352413misassigns
missions10311903missions
musings10389543musings
nasions73112383nasions
nosings8349593nosings
opsins8411713opsi_ns
osseins736133osseins
passages1139513passages
passing104318423passi_ng
passion9310883passion_
passives13228823passives
preassigns1343553preassigns
quassins1735793quassi_ns
raisings9338443raisings
raisins72715343raisi_ns
raspings11337853raspings
reassign955423reassign_
reigns74811753_reigns
resign74212583resign_
resins64528773resi_ns
risings83211893risings
rosins64521863rosi_ns
sabins85521983sabi_ns
saigas74114293_saigas
sains55639973_sai_ns
sapiens9310173sapiens
sarins63932623sari_ns
sasin54626573sasi_n_
sassies74719263sassi_es
sassing84615553sassi_ng
satins64930483sati_ns
savings114412953savings
savins93923133savi_ns
sayings113610833sayings
scions82612243_scions
sessions839723sessions
shins85131043_shi_ns
sighs95416743__sighs
sign55523053__sign_
signa66114703__signa
sings65532703__sings
sins46755273__si_ns
skins94723463_ski_ns
slings74618013_slings
soigne74310033_soigne
spins75327983_spi_ns
stings76220183_stings
swigs96213663_swig_s
swings104714453_swings
tassies74918933tassi_es
visions10311023visions
washings15419273washings

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.406440125.6
2DLD Change Limit1340272126.75019855.9
3Display Results2122120.0802650.0
 (SQL Overall)1786912127.23624694.7
 
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.