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

146 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
gyration123776(None) 
gyrations1336921gyrations
aeration8319932aeration
duration9312692duration
gelation93014432gelation
gratin74520582g_rati_n
gyrating1337452gyrating
gyrational1444742gyrational
gyrator1135722gyrat_or
hydration1646072hydration
oration71617712_oration
ration64226012__ration
ablation10312433ablation
abrasion1046623abrasion
acylation1448653acylation
adnation9310783adnation
adoration10311313adoration
aerations9317903aerations
agitation10311223agitation
agnation9311723agnation
alation72920553_alation
aviation11312743aviation
carnation11312943carnation
cation83925503__cation
ceratin93020163cerati_n
citation10314363citation
conation101420883conation
craton84517193_crat_on
creation102816513creation
darnation1039823darnation
delation92318083delation
dilation92215463dilation
donation91513783donation
dotation91412733dotation
durations10311463durations
dynatron1243623dynatron
elation73620453_elation
enation73419233_enation
equation17310483equation
erasion7311963_erasion
fetation11613143fetation
figuration1445913figuration
fixation1837073fixation
formation1439423formation
fraction1359483_fraction
furcation1448353furcation
gabion93211033g__abion
gelatin83514733gelati_n
gelations102513093gelations
gemmation1445963gemmation
generation11312423generation
geraniol945143geraniol
gestation10310663gestation
gigaton946343gigat_on
gnathion1243443g_nathion
gradation11107713gradation
gradin83517483g_radi_n
grain65126253g_ra_i_n
gratify1436113g_ratify
gratine84719193g_ratine
grating93923183g_rating
gratins84119183g_ratins
gratis74819243g_rati_s
graviton1244303g_raviton
grunion835433g_runion
gumption1343983gumption
gustation1047963gustation
guttation1046173guttation
gyrate104912523gyrat__e
gyrated12428413gyrat_ed
gyrates113610263gyrat_es
gyrators1246003gyrators
gyratory1544173gyratory
gyrfalcon1891013gyrfalcon
gyron95314623gyr___on
halation11313853halation
himation1339753himation
hydrations1745283hydrations
ideation9310493ideation
illation8311943illation
iodation9310383iodation
iteration9515033iteration
kation104315683__kation
keratin113314153kerati_n
lavation1139973lavation
laxation1538423laxation
legation92412933legation
libation102411363libation
libration111510163libration
ligation92313093ligation
lobation102110553lobation
location102113913location
lunation8311923lunation
luxation1538233luxation
marathon1346813marathon
migration12179703migration
mutation101412883mutation
narration9310063narration
natation81513933natation
nation64322803__nation
negation92913023negation
nervation12610243nervation
nidation9410583nidation
nitration9313443nitration
notation81414603notation
novation111710013novation
nutation81513103nutation
oblation1039863oblation
operation11314003operation
orations81515803_orations
ovation101510023_ovation
parathion1446173parathion
portion9615493por_tion
potation101716783potation
proration11415983proration
pupation1269503pupation
purgation1247393purgation
ratio55227583__ratio_
rations74123433__rations
ratios64922673__ratios
ratoon64417373__ratoon
ratton64116123__ratton
relation82619773relation
rogation91612053rogation
rotation81615453rotation
sedation9312453sedation
seriation9318063seriation
serration9414063serration
solation8916153solation
sorption1037513sorption
station72717243_station
striation9313483striation
sudation9310803sudation
tarnation9310093tarnation
taxation1537993taxation
thyratron15112783thyratron
titration9310543titration
traction10412683_traction
vacation131911893vacation
variation12312393variation
venation11513503venation
vernation12311083vernation
vexation1838783vexation
vibration14138203vibration
vocation132311983vocation
zonation171410723zonation

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 Filter1786911461620.420425454.8
2DLD Change Limit1461621466.14323793.3
3Display Results1461460.0632317.5
 (SQL Overall)1786911466.62626968.2
 
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.