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

119 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
reassign95542(None) 
preassign1244571preassign
reassigns1074351reassigns
assign736782__assign
preassigns1343552preassigns
realign838762rea_lign
reassigned1243602reassigned
redesign1045072redesign
repassing12249422repassing
resign74212582re__sign
amassing1138003amassing
assigns836193__assigns
biassing11307263biassing
brassing112612303brassing
breasting1239583breasting
ceasing104118263cea_sing
cessing103814813ce_ssing
cession939813ce_ssion
classing113211793classing
creasing113314443crea_sing
crevassing1643533crevassing
deashing134210953deashing
degassing1234823degassing
design8408933de__sign
dressing102810423dre_ssing
easing74926463_ea_sing
easting84924303_easting
ensign737523_e_nsign
erasing8317963era_sing
erasion7311963era_sion
feasing113916653fea_sing
feasting122011323feasting
fessing113812863fe_ssing
gassing94216333_gassing
glassing10329973glassing
grassing103311973grassing
greasing102811393grea_sing
hearsing1239383hearsing
hessian1035853he_ssian
jessing153710623je_ssing
leashing123310313leashing
leasing83920163lea_sing
massing104318023_massing
messing103916393me_ssing
misassign1243223misassign
passing104318423_passing
passion9310883_passion
preassigned1552603preassigned
pressing112516443pre_ssing
quassin1645943quassi_n
raisin62716923r_aisi_n
raising83220533r_aising
rasing74330833r_a_sing
rasping104316253r_asping
rassling939013r_assling
reaching143317203reaching
reacting113317893reacting
reaction10612603reaction
readding11411363readding
reading93327213rea_ding
readying13410223readying
reagin74915533rea_gi_n
realigns936253rea_ligns
realising10313173realising
reaming103924013rea_ming
reaping103621213rea_ping
rearing83128783rea_ring
rearming111413613rearming
reason62616333rea_s_on
reasoning10310203reasoning
reassail845753reassail
reassails945293reassails
reassert8313673reassert
reassess836513reassess
reassigning1343643reassigning
reassort8410683reassort
reassume1044633reassume
reassuming1343703reassuming
reassure847343reassure
reassuring1155943reassuring
reaving113820533rea_ving
recasting122414233recasting
recessing12611013recessing
recession1149103recession
recision10310273recision
reconsign1245243reconsign
recusing112512883recusing
redesigns1144073redesigns
redskin1286023redski_n
reesting93118273reesting
refashion1543353refashion
refusing122310873refusing
rehashing1647113rehashing
reign65015193re___ign
reissuing1034613reissuing
relapsing1236843relapsing
remising112516453remising
remission1147333remission
repassage1243123repassage
repasting122312843repasting
reposing111213803reposing
reraising10313773reraising
rerising93017783rerising
resawing122311433resawing
resaying122512453resaying
resigns83910963re__signs
resin54131053re__si_n
resting85031183re_sting
retasting102513413retasting
reusing82516783re_using
revising122714403revising
revision1138713revision
rewashing1676903rewashing
roasting93012703roasting
sassing84615553_sassing
session739763se_ssion
teasing83918513tea_sing
yeasting12188923yeasting
yessing113210063ye_ssing

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.1561145455.1
2DLD Change Limit1461621198.21617789.9
3Display Results1191190.0502380.0
 (SQL Overall)1786911198.42221217.2
 
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.