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 “gyrators” with Change Limit: [1] [2] [3] [4]

You can choose a higher Change Limit to return more words, although it will take longer.
to automatically increase the Change Limit after seconds.

95 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
gyrators124599(None) 
gyrator1135711gyrator_
gyratory1544161gyratory
aerators8315612aerators
curators10311722curators
gators74115832g__ators
grantors93810352g_rantors
graters85419742g_raters
gyrates113610262gyrat_es
gyrations1336922gyrations
hydrators1645682hydrators
orators7313822_orators
abators94413083_abators
ablators1069873ablators
aerator7314843aerator_
agitators1046623agitators
aviators11169903aviators
barrators1148393barrators
citators10310253citators
craters95021893_craters
cratons94316033_cratons
creators102814403creators
curator9312213curator_
delators92314823delators
dilators93213193dilators
donators9310403donators
equators1737473equators
fraters103517213_fraters
garters84218233gar_ters
gaters74728643g__aters
gator64416033g__ator_
gelatos83111513gelato_s
generators1147533generators
genitors937423genitors
gigatons1046053gigatons
girasols984273girasols
glamors1068113g_lamors
gloaters9288863gloaters
graders94716013g_raders
grafters12409193g_rafters
granters93614143g_ranters
grantor84010933g_rantor_
grater74625443g_rater_
grates75429893g_rat_es
gratins84119183g_ratins
gratis74819243g_rat_is
gravers114515273g_ravers
grazers175112453g_razers
guarantors1142433guarantors
gypsters1434023gypsters
gyrases11368313gyra_ses
gyrate104912523gyrat__e
gyrated12428413gyrat_ed
gyrating1337453gyrating
gyration1237763gyration
gyrons105511223gyr__ons
gyros95616483gyr__o_s
heritors11310903heritors
hydrator1545763hydrator_
juratory1845183juratory
kraters114212343_kraters
legators92811033legators
levators11249283levators
locators102910433locators
migrators1247543migrators
miradors1146853miradors
moratory1347823moratory
narrators947863narrators
negators92411173negators
nitrators949213nitrators
operators11410753operators
orator6314533_orator_
oratory1039403_oratory
paradors113411903paradors
praetors1039833_praetors
praters94921653_praters
pretors9316803_pretors
pyritous1344933pyritous
raptors94213353__raptors
raters63936583__raters
ratos55528763__rato_s
razors154711663__razors
relators83316123relators
rotators8310203rotators
rotors64917953__rotors
sartors7314963sar_tors
senators8312953senators
stators73915583_stators
stratous8410703stratous
titrators948383titrators
tractors10312563_tractors
traitors8310793_traitors
varactors1446393varactors
viators102712023_viators
vibrators14237253vibrators

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 Filter1786911461620.1561145455.1
2DLD Change Limit146162957.51619446.8
3Display Results95950.0462065.2
 (SQL Overall)178691957.71823152.5
 
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.