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

113 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
flotation126781(None) 
floatation1344681floatation
flotations1366871flotations
dotation91412732_dotation
fetation11613142f_etation
flirtation1354822flirtation
floatations1444102floatations
floriation1367792floriation
foliation121110792foliation
lobation102110552_lobation
location102113912_location
notation81414602_notation
potation101716782_potation
quotation18146972quotation
rotation81615452_rotation
adoration10311313adoration
agitation10311223agitation
alation72920553al__ation
allocation1248573allocation
annotation1047753annotation
avocation14168993avocation
bilocation1446123bilocation
bloviation1544003bloviation
citation10314363_citation
clavation1447003clavation
collation11313993collation
coloration12913183coloration
conation101420883_conation
corotation12410973corotation
defloration1547263defloration
denotation11311083denotation
dentation10315243dentation
dictation12810563dictation
dilatation1147393dilatation
donation91513783_donation
dotations101411633_dotations
elation73620453el__ation
elevation1239233elevation
elocution1145673elocution
elongation1145353elongation
evocation142010293evocation
fellation1238843fellation
fetations12511383f_etations
filiation121110243filiation
filtration1346433filtration
fixation1837073f_ixation
flatiron1144623fl__atiron
flection13239563fl_ection
flirtations14104263flirtations
floatier1136983flo_atier
floating123111883flo_ating
flokati1443483flokati__
flokatis1543123flokati_s
floriations1476913floriations
fluctuation1653073fluctuation
foliations1399943foliations
formation1439423formation
furcation1448353furcation
gestation10310663gestation
gustation1047963gustation
guttation1046173guttation
illation8311943il_lation
imitation11510853imitation
iodation9310383_iodation
isolation9311643isolation
jactation1838143jactation
lactation11310813lactation
lavation1139973_lavation
laxation1538423_laxation
legation92412933_legation
libation102411363_libation
ligation92313093_ligation
lobations11219613_lobations
locations112512743_locations
locution10227663_locution
lotion65716523_lo__tion
lunation8311923_lunation
luxation1538233_luxation
mentation11313983mentation
mutation101412883_mutation
natation81513933_natation
nictation1189273nictation
notations91512973_notations
novation111710013_novation
nutation81513103_nutation
oration71617713__oration
ovation101510023__ovation
ozonation1845673ozonation
peltation11312963peltation
phonation1439393phonation
placation1339773placation
planation11310123planation
plantation1248533plantation
plication13311683plication
potations111615073_potations
probation13412183probation
pronation11415703pronation
proration11415983proration
quotations19146283quotations
relocation12312113relocation
restation9316913restation
rogation91612053_rogation
rotations91613843_rotations
saltation9312003saltation
salutation1048903salutation
siltation939213siltation
solation8916153_solation
solvation1237773solvation
station72717243__station
ululation938093ululation
violation1238443violation
vocation132311983_vocation
zonation171410723_zonation

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.420425454.8
2DLD Change Limit1486411136.50022867.8
3Display Results1131130.0462456.5
 (SQL Overall)1786911136.96625651.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.