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

144 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
fixations193635(None) 
fixation1837071fixation_
affixations2443852affixations
citations11312502citations
dilations102614452dilations
fetations12511382fetations
fictions132410742fi_ctions
filiations13119092filiations
fixatifs2162072fixati_fs
fixating1936182fixati_ng
fixatives2243352fixatives
himations1438802himations
infixations2146692infixations
laxations1637622laxations
libations112510442libations
ligations102111992ligations
luxations1637272luxations
nidations1039212nidations
taxations1636862taxations
vexations1937752vexations
ablations11311513ablations
adnations1039753adnations
aerations9317903aerations
affixation2344393affixation_
agitations11310063agitations
agnations10310033agnations
alations82518893_alations
animations12312193animations
aviations12311553aviations
cations94524143__cations
ciliations121111003ciliations
citation10314363citation_
conations111318903conations
creations112614543creations
delations102616593delations
diatrons939613di_atrons
dictations1389703dictations
dictions111812673di_ctions
dilation92215463dilation_
dilutions10248583dilutions
donations101112353donations
dotations101411633dotations
durations10311463durations
elations83719123_elations
enations83316903_enations
epilations12311713epilations
equations1839493equations
exactions1838923_exactions
factions133013063f_actions
fanions103713073f__anions
fellations1338063fellations
fetation11613143fetation_
fiction122010733fi_ction_
figurations1545083figurations
filiation121110243filiation_
filtrations1445623filtrations
fissions1138033fi_ssions
fixates1737393fixat__es
fixatif2054633fixati__f
fixative2145083fixati_ve
fixities1838213fixiti_es
flatirons1244483f_latirons
flections14239213flections
flirtations14104263flirtations
flotations1366873flotations
foliations1399943foliations
formations1538203formations
fractions1449103fractions
frictions1448033frictions
fruitions12106113fruitions
fumigations1744923fumigations
functions1437743functions
furcations1547533furcations
gelations102513093gelations
gigatons1046053gigat_ons
gyrations1336923gyrations
halations12312393halations
himation1339753himation_
ideations1039903ideations
illations9311393illations
imitations1259963imitations
inactions1139323_inactions
infixation2047533infixation_
iodations1039113iodations
isatins7310773_isati_ns
kations114013663__kations
lavations1238973lavations
laxation1538423laxation_
legations102711923legations
libation102411363libation_
librations12149063librations
ligation92313093ligation_
lineations1039543lineations
liquations1945623liquations
lobations11219613lobations
locations112512743locations
lunations9310723lunations
luxation1538233luxation_
migrations13168683migrations
mutations111211453mutations
natations91412493natations
nations74720563__nations
negations102811963negations
nictations1278313nictations
nidation9410583nidation_
nitrations10312033nitrations
notations91512973notations
novations12139003novations
nutations91411763nutations
oblations1139373oblations
orations81515803_orations
ovations11149263_ovations
oxidations1845443oxidations
pinnations1236883pinnations
pixilations2045333pixilations
plications14310493plications
potations111615073potations
privations15310103privations
pupations1338123pupations
rations74123433__rations
relations92418333relations
rogations101510823rogations
rotations91613843rotations
ruinations1039603ruinations
sedations10311253sedations
siltations1038553siltations
sinuations1039413sinuations
situations1038433situations
solations9814623solations
stations82415223_stations
sudations1039903sudations
suffixations2562543suffixations
taxation1537993taxation_
titrations1039173titrations
urinations10310693urinations
vacations141910553vacations
venations12311723venations
vexation1838783vexation_
vexatious1944103vexatious
vibrations15157373vibrations
violations1337963violations
vitiations1338743vitiations
vocations141911423vocations
zonations18139313zonations

Search took 8 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 Filter1786911486410.423422437.4
2DLD Change Limit1486411447.34320242.5
3Display Results1441440.0761894.7
 (SQL Overall)1786911447.84222786.4
 
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.