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

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

112 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
irresolutions1316237(None) 
irresolution12132411irresolution_
resolutions11117792__resolutions
resolution1097733__resolution_
revolutions1497633__revolutions
absolutions1344714__absolutions
coevolutions1754084_coevolutions
desolations12310594__desolations
devolutions15106264__devolutions
dissolutions13144924_dissolutions
evolutions13107044___evolutions
exsolutions1844014__exsolutions
insolations1149184i__nsolations
involutions1445904i__nvolutions
irreligions1252044irre__ligions
irresolute1051494irresolut___e
irresolutely1561294irresolut_ely
irresoluteness1471434irresoluteness
isolations10310694i___solations
microevolutions2282334microevolutions
nonsolutions1254174_nonsolutions
prerevolution1861944prerevolution_
resorptions1347234__resorptions
revolution13117564__revolution_
solutions988884____solutions
absolution1244405__absolution_
arrogations12126485arr__ogations
circumvolutions2472455circumvolutions
coevolution1654225_coevolution_
consolations1449745_consolations
convolutions1745195_convolutions
correlations1447865corre__lations
crenelations1446185_crenelations
crenulations1446495_crenulations
demolitions1446525__demolitions
deregulations1545205deregulations
desolation11311405__desolation_
desorptions1445995__desorptions
devolution1486285__devolution_
disrelations1348505disre__lations
dissolution12145025_dissolution_
elocutions1245965___elocutions
elutions82513055___e__lutions
evolution12117095___evolution_
exsolution1743765__exsolution_
forestations1546325fores_tations
immolations1545475i__mmolations
impersonations1863655impersonations
infestations1546625infes_tations
ingestions1197595inges___tions
insolation10410215i__nsolation_
insulations11310235i__nsulations
interpolations1657435interpolations
involution1345945i__nvolution_
irradiations1394885irr_adiations
irrealities1146215irre_aliti_es
irreligion1151825irre__ligion_
irreligious1252295irre__ligious
irresoluble1362155irresolu__ble
irrigations1246945irr__igations
irritations1147835irr__itations
irruptions1243895irr___uptions
isolation9311645i___solation_
macroevolutions2281615macroevolutions
microevolution2182645microevolution_
nonsolution1154745_nonsolution_
percolations1648055per_colations
persecutions1654795per_secutions
personations1448395per_sonations
precautions1546555_pre_cautions
preclusions1544665_pre_clusions
prelusions1256375_pre__lusions
premonitions1646855_premonitions
prenotions1248295_preno__tions
preoptions1447645_pre_o_ptions
preportions1548265_prepo_rtions
prepositions16108305_prepositions
preselections17144445_preselections
presumptions18153885_presumptions
prolusions1245885_pr__olusions
prosecutions1645615_prosecutions
recautions1247815__re_cautions
reclusions1246245__re_clusions
reescalations1573785_reescalations
reevaluations1654275_reevaluations
reflations13311235__re_flations
regulations12310715__regulations
relations92418335__re__lations
relocations13311145__relocations
remotions1149705__remo__tions
renovations1448425__renovations
repletions1247475__re_pletions
repositions131110165__repositions
reregulations1455715reregulations
resaluting1137395__resaluti_ng
resections121513035__res_ections
resolutes968195__resolut__es
resorption1247255__resorption_
restations10315845__res_tations
restitutions1275705__restitutions
restorations12410965__restorations
resumptions15154595__resumptions
retortions1049145__reto_rtions
revaluations1557635__revaluations
revelations14410305__revelations
revocations16410315__revocations
revolutionise16134485__revolutionise
revolutionist16106185__revolutionist
solations9814625____solations
solution889595____solution_
translations1258375trans_lations
volutions12108395____volutions

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 Filter1786911247900.373479064.3
2DLD Change Limit1247901128.25015126.1
3Display Results1121120.0631777.8
 (SQL Overall)1786911128.68620572.3
 
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.