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

110 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
titrations103917(None) 
nitrations10312031nitrations
titration9310541titration_
citations11312492cit_ations
filtrations1445622filtrations
iterations10413822iterations
librations12149062librations
literations11610572literations
migrations13168672migrations
nitration9313442nitration_
situations1038422situations
titivations1446262titivations
titrating10310112titrati_ng
titrators948352titrat_ors
triturations1245682triturations
vibrations15157372vibrations
vitiations1338742vitiations
actuations1239293actuations
adorations11310223adorations
aerations9317903_aerations
agitations11310063agit_ations
alterations11511653alterations
arbitrations1445753arbitrations
attractions1376393attractions
attritions1066793attritions
castrations13410053castrations
ciliations121110993ciliations
citation10314363cit_ation_
detractions14118263detractions
detritions1148953detritions
dictations1389693dictations
dilations102614453di_lations
distractions1548713distractions
dotations101411623dot_ations
durations10311463_durations
emigrations14187153emigrations
etiolations1147383etiolations
extractions2077733extractions
fetations12511383fet_ations
figurations1545073figurations
filiations13119093filiations
filtration1346433filtration_
fixations1936353fi_xations
flirtations14104263flirtations
guttations1145593guttations
gyrations1336923_gyrations
himations1438803hi_mations
hydrations1745273hydrations
ideations1039903_ideations
illations9311393_illations
imitations1259953imit_ations
initiations11410723initiations
iodations1039113_iodations
iteration9515033iteration_
itinerations1245673itinerations
libations112510443li_bations
liberations1358933liberations
libration111510163libration_
ligations102111983li_gations
lineations1039543lineations
liquations1945613liquations
literation10511403literation_
litigations1247333litigations
lustrations1147623lustrations
maturations1348433maturations
migration12179693migration_
mitigations1447623mitigations
mutations111211453mut_ations
narrations1038933narrations
natations91412493nat_ations
nictations1278313nictations
nidations1039213ni_dations
nitrating10312673nitrati_ng
nitrators949203nitrat_ors
notations91512973not_ations
nutations91411763nut_ations
nutritions1066513nutritions
obturations13116423obturations
operations12312933operations
orations81515793__orations
pinnations1236883pinnations
potations111615063pot_ations
prorations12314433prorations
rations74123433___rations
reiterations12410853reiterations
retractions13910343retractions
rotations91613843rot_ations
satiations10312093satiations
saturations1148573saturations
serrations10313053serrations
siltations1038543siltations
sinuations1039393sinuations
situation949423situation_
stations82415213_st_ations
striations10312773_striations
tarnations1038903tarnations
taxations1636863t_axations
tetragons1045333tetra_gons
thyratrons16132763thyratrons
titillations1244443titillations
titivation1347033titivation_
titrates82314643titrat__es
titrator858543titrat_o_r
tolerations1158113tolerations
tractions11511613__tractions
trituration1146653trituration_
vibration14138203vibration_
violations1337963violations
vitiation1239563vitiation_
vitrains1138283vitra_i_ns

Search took 10 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 Filter1786911406030.1561145455.1
2DLD Change Limit1406031108.89015815.9
3Display Results1101100.0631746.0
 (SQL Overall)1786911109.10919617.0
 
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.