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

88 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
nitrator84955(None) 
nitrators949211nitrators
titrator858541titrator
citator9310122cit_ator
initiator998112initiator
literator948682literator
migrator1147872migrator
narrator847562narrator
nitrate72017012nitrat_e
nitrated92213152nitrated
nitrates82516222nitrates
nitration9313442nitration
titrators948382titrators
vibrator13227342vibrator
vitiator1147042vitiator
actuator1046643actuator
aerator7314843_aerator
agitator946713agit_ator
animator101410293ani_mator
arbitrator1254393arbitrator
attractor1145823attractor
barrator1048403barrator
castrator1147643castrator
citators10310253cit_ators
citatory1347213cit_atory
citrate92216803citrat_e
citrated112712253citrated
citrates102315093citrates
curator9312213_curator
denigrator1245223denigrator
detractor12147213detractor
dictator1147263dictator
dilator82712783di_lator
extractor1846723extractor
gyrator1135713_gyrator
hydrator1545763hydrator
imitator1047113imit_ator
infiltrator1453023infiltrator
inflator1158033inflator
infractor1465943infractor
initiators10127313initiators
initiatory13125813initiatory
integrator1157123integrator
intrados946563intrados
irater65218353_i_rater
liberator1147063liberator
libratory14255803libratory
literators1048103literators
litigator1045503litigator
migrators1247543migrators
migratory1545343migratory
mirador1046503mi_rador
mitigator1245413mitigator
narrater838723narrater
narrators947863narrators
natatory1146603nat_atory
negator83010673n_egator
nitrating10312673nitrating
nitrations10312033nitrations
nitrite72314463nitrit_e
nitrites82313453nitrites
nitro54914353nitr__o_
nitros64214123nitr__os
nitroso7326453nitroso_
numerator1145583numerator
obturator1144703obturator
operator10310093operator
orator6314533__orator
piscator1246923piscator
retractor11218513retractor
rotator7310833rot_ator
saturator946613saturator
stator64015483_st_ator
tiltrotor951803tiltrotor
titrate72215573titrat_e
titrated92611683titrated
titrates82314663titrates
titration9310543titration
tractor9311333__tractor
traitor7310123__traitor
triturator1054123triturator
viator93211833vi__ator
vibrato12247383vibrato_
vibrators14237253vibrators
vibratory17235563vibratory
vibratos13217483vibratos
violator1146283violator
vitiators1246923vitiators

Search took 9 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.423422437.4
2DLD Change Limit146162887.67019056.3
3Display Results88880.0332666.7
 (SQL Overall)178691888.12621990.0
 
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.