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

116 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
solvations133683(None) 
salvations1338131salvations
solations9814621sol_ations
solvation1237771solvation_
collations12312852collations
foliations1399942foliations
isolations10310692isol_ations
novations12139002no_vations
ovations11149262_o_vations
salivations1448732salivations
saltations10310622saltations
salvation1239292salvation_
siltations1038552siltations
solation8916152sol_ation_
solutions988882sol_utions
solvating1336442solvati_ng
spoliations1347692spoliations
sulcations1289582sulcations
sulfations13107812sulfations
ablations11311513abl_ations
alations82518893_al_ations
bloviations1643753bloviations
bolections14137293bolections
ciliations121111003ciliations
clavations1546183clavations
cognations1339593cognations
collation11313993collation_
colorations13911893colorations
conations111318903co_nations
connations12312943connations
delations102616593del_ations
desolations12310593desol_ations
dilations102614453dil_ations
donations101112353do_nations
dotations101411633do_tations
elations83719123_el_ations
elevations1338633elevations
estivations1449273estivations
fellations1338063fellations
filiations13119093filiations
flotations1366873flotations
foliation121110793foliation_
formations1538203formations
gelations102513093gel_ations
halations12312393hal_ations
illations9311393_illations
insolations1149183insol_ations
iodations1039113io_dations
isolation9311643isol_ation_
lallations1038743lallations
lavations1238973_lavations
lobations11219613lo_bations
locations112512743lo_cations
motivations1647093motivations
nervations1359483nervations
notations91512973no_tations
novation111710013no_vation_
oblations1139373_oblations
obviations1545463_obviations
olfactions1563873_olfactions
orations81515803_o_rations
ovation101510023_o_vation_
palmations1438733palmations
palpations1437653palpations
peltations12311553peltations
pollutions1245433pollutions
potations111615073po_tations
privations15310103privations
pulsations1236373pulsations
relations92418333rel_ations
rogations101510823ro_gations
rotations91613843ro_tations
salivation1349813salivation_
saltation9312003saltation_
salutations1147643salutations
salvational1443713salvational
salvationism1763113salvationism
salvationist1554403salvationist
satiations10312113satiations
scalations1239783scalations
sedations10311253s_edations
selections12310873selections
sensations1059853sensations
seriations10316683seriations
serrations10313093serrations
siltation939213siltation_
sinuations1039413sinuations
situations1038433situations
solanins8310513sol_ani_ns
solating9315593sol_ati_ng
solions7513753sol___ions
solitons849593sol_it_ons
solmizations2346633solmizations
solution889593sol_ution_
solvates11249673solvat__es
sonications1349953sonications
sorptions1137123so_rptions
sortitions1046423sortitions
spallations1356103spallations
spoliation1248423spoliation_
starvations1445053starvations
stations82415223s__tations
striations10312793striations
sublations12410113sublations
sudations1039903s_udations
sulcation11710733sulcation_
sulfation1288783sulfation_
summations1456783summations
tolerations1158133tolerations
vallations1339093vallations
valuations1348783valuations
violations1337963viol_ations
vocations141911423vo_cations
volitions1288663vol_itions
volutions12108393vol_utions
zonations18139313zo_nations

Search took 7 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.410435831.7
2DLD Change Limit1406031165.76324397.5
3Display Results1161160.0631841.3
 (SQL Overall)1786911166.23628654.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.