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

224 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
ablations1131151(None) 
ablation10312431ablation_
ablutions1146601ablutions
alations82518891a_lations
oblations1139371oblations
ablating11311992ablati_ng
ablatives1445502ablatives
ablators1069872ablat_ors
ablution1047222ablution_
abolitions1246652abolitions
abortions1147782abortions
abrasions1145812abrasions
acylations1547602acylations
adnations1039752adnations
adulations11310122adulations
aerations9317902aerations
agnations10310032agnations
alation72920552a_lation_
ambulations1547112ambulations
aviations12311552aviations
delations102616592delations
dilations102614452dilations
elations83719122_elations
gelations102513092gelations
halations12312392halations
illations9311392illations
lallations1038742lallations
oblation1039862oblation_
relations92418332relations
solations9814622solations
sublations12410112sublations
tabulations1346852tabulations
vallations1339082vallations
abandons1145353ab_andons
abating10413973ab_ati_ng
abatis84317933ab_ati__s
abatises10311013ab_atises
abators94413083ab_at_ors
abdications1657653abdications
abductions15125383abductions
aberrations1346693aberrations
abjections2145673abjections
abjurations2045143abjurations
ablates92416903ablat__es
ablative1348243ablati_ve
ablator939843ablat_o_r
ablins8316193abl__i_ns
abnegations1444923abnegations
abolition1147053abolition_
abortion1048103abortion_
abrasion1046623abrasion_
abreactions1544193abreactions
abrogations14116463abrogations
abruptions1443843abruptions
absolutions1344713absolutions
abstains1047323abstai_ns
abutilons1142963ab_utilons
actions94218513a__ctions
actuations1239293actuations
acylation1448653acylation_
adaptions1245223adaptions
additions1186333additions
adnation9310783adnation_
adoptions1245783adoptions
adorations11310233adorations
adulation10311013adulation_
aeration8319933aeration_
agitations11310063agitations
agnation9311723agnation_
alanins7315803a_lani_ns
albatross1142573albatross
alkylations1843353alkylations
allantoins1083723allantoins
allegations1246043allegations
allocations1347773allocations
allusions946013allusions
alluvions1254373alluvions
ambitions1346343ambitions
ambulation1447873ambulation_
amotions1069843a_motions
angulations1268053angulations
animations12312193animations
annulations1167833annulations
arcuations1249343arcuations
auctions104012143a_uctions
auditions1078753auditions
aviation11312743aviation_
avocations15168683avocations
basions94213953_b_asions
bastions10411693_bastions
batons85519423_b_at_ons
blains84516373_bla_i_ns
blazons1836163_bla_zons
carnations12311353carnations
caseations1258303caseations
cassations1276873cassations
cations94524143__cations
caudations13108223caudations
causations1268143causations
chelations1539073chelations
ciliations121111003ciliations
citations11312503citations
clarions10310493_clarions
collations12312853collations
conations111318903conations
creations112614543creations
damnations1337083damnations
darnations1138413darnations
dealations11311373dealations
deflations1439713deflations
delation92318083delation_
deletions102610933deletions
dilation92215463dilation_
dilutions10248583dilutions
donations101112353donations
dotations101411633dotations
durations10311463durations
elation73620453_elation_
elutions82513053_elutions
emulations12310943emulations
enations83316903_enations
epilations12311713epilations
equations1839493equations
fellations1338063fellations
fetations12511383fetations
filiations13119093filiations
fixations1936353fixations
flatirons1244483_flatirons
foliations1399943foliations
gelatins93414093gelati_ns
gelation93014433gelation_
gyrations1336923gyrations
habitations1646883habitations
halation11313853halation_
himations1438803himations
ideations1039903ideations
illation8311943illation_
inflations13310323inflations
iodations1039113iodations
isolations10310693isolations
jactations1936893jactations
jubilations2045363jubilations
kations114013663__kations
lactations1239423lactations
lallation939493lallation_
latinos73613803__latinos
laudations1146843laudations
lavations1238973lavations
laxations1637623laxations
legations102711923legations
libations112510443libations
librations12149063librations
ligations102111993ligations
lobations11219613lobations
lobulations1346213lobulations
locations112512743locations
lotions74614763__lotions
lunations9310723lunations
luxations1637273luxations
maculations1569623maculations
malathions1543873malathions
mutations111211453mutations
narrations1038943narrations
natations91412493natations
nations74720563__nations
negations102811963negations
nidations1039213nidations
notations91512973notations
novations12139003novations
nutations91411763nutations
obligations1446143obligations
oblivions1443243oblivions
obviations1545463obviations
orations81515803_orations
ovations11149263_ovations
ovulations1337973ovulations
palliations1347723palliations
palmations1438733palmations
palpations1437653palpations
peltations12311553peltations
platoons1038683_platoons
potations111615073potations
pulsations1236373pulsations
pupations1338123pupations
radiations11311923radiations
rations74123433__rations
reflations13311233reflations
relation82619773relation_
rogations101510823rogations
rotations91613843rotations
sabatons1037843sab_at_ons
saltations10310623saltations
salvations1338133salvations
satiations10312113satiations
scalations1239783scalations
sedations10311253sedations
sibilations13127933sibilations
siltations1038553siltations
solation8916153solation_
solutions988883solutions
solvations1336833solvations
spallations1356103spallations
stations82415223_stations
sublation11311013sublation_
sudations1039903sudations
sulcations1289583sulcations
sulfations13107813sulfations
tabulation1247813tabulation_
tarnations1038903tarnations
taxations1636863taxations
trabeations1345373trabeations
ululations1037143ululations
vacations141910553vacations
vallation1239743vallation_
valuations1348783valuations
variations13310773variations
venations12311723venations
vexations1937753vexations
vibrations15157373vibrations
violations1337963violations
vocations141911423vocations
volitions1288663volitions
volutions12108393volutions
zonations18139313zonations

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 Filter1786911486410.423422437.4
2DLD Change Limit1486412246.25023782.6
3Display Results2242240.1102036.4
 (SQL Overall)1786912246.78326343.9
 
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.