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 “assigned” with Change Limit: [1] [2] [3] [4]

You can choose a higher Change Limit to return more words, although it will take longer.
to automatically increase the Change Limit after seconds.

93 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
assigned104463(None) 
assignee944841assignee
assigner944851assigner
aligned9128552a_ligned
assign736782assign__
assignat945682assignat
assignees1043502assignees
assigners1044412assigners
assignor942992assignor
assigns836192assign_s
assisted936232assisted
cosigned1235722cosigned
designed1136942designed
reassigned1243602reassigned
resigned1038862resigned
signed83413752__signed
unassigned1262472unassigned
unsigned1037562unsigned
affined1436413affi_ned
aliened81011743a_liened
aligner8108313a_ligner
alined75221403a_li_ned
arraigned11103033arraigned
arsine64021043arsi_ne_
arsines73518833arsi_nes
aspired1068173aspi_red
assagaied1142173assagaied
assailed945323assailed
assayed1135593ass_ayed
assegaied1142503assegaied
assented957523assented
asserted957913asserted
assessed945023assessed
assignats1044003assignats
assigning1144673assigning
assignment1353893assignment
assignors1043243assignors
assister836753assister
assize1538633assi_ze_
assizes1638453assi_zes
assoiled935023assoiled
assorted956603assorted
assuaged1044383assuaged
assumed1065293ass_umed
assured858373ass_ured
asswaged1343333asswaged
astringed1145693astringed
awninged1342433awninged
basined10310003basi_ned
bassinet10312843bassi_net
bastioned1246863bastioned
cassine93817283cassi_ne_
cassines103116613cassi_nes
coigned11418663_coigned
consigned1346323consigned
cosigner1135953cosigner
deigned1037503_deigned
designee1087753designee
designer1036543designer
eloigned1043423eloigned
fashioned16114463fashioned
feigned1245353_feigned
fissioned1345523fissioned
insigne837673insigne_
lesioned936903lesioned
maligned1285773maligned
massaged1236753massag_ed
misassigned1552033misassigned
missioned1248603missioned
ossified1276433ossified
passaged1236243passag_ed
preassigned1552603preassigned
reigned949213_reigned
resigner937793resigner
resined84522653resi_ned
rosined84911913rosi_ned
sained75424243_sai_ned
seined74023063_sei_ned
shined104620783_shi_ned
shinned114310923_shinned
sighed113712053__sighed
signee73617233__signee
signer74015633__signer
signet73621153__signet
singed85422293__singed
sinned73818413__sinned
skinned12387293_skinned
soigne74310033_soigne_
soignee8279133_soignee
spined95423943_spi_ned
swigged13327183_swigged
swinged123810793_swinged
visioned1247013visioned

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.423422437.4
2DLD Change Limit146162937.64019131.2
3Display Results93930.0462021.7
 (SQL Overall)178691938.10922036.1
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.