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

81 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
barrators114839(None) 
barraters1138041barraters
barrator1048401barrator_
barretors1146241barretors
narrators947861narrators
aerators8315612_aerators
barrater10310152barrater_
barratry13114472barrat_ry
barretor1046712barretor_
narraters946702narraters
narrator847562narrator_
warrantors1343042warrantors
abators94413093_a_bators
ablators1069883_ablators
abrogators1345233abrogators
aerator7314843_aerator_
arrayers11125853_arrayers
arrestors958033_arrestors
arrogators1145373_arrogators
aviators11169913_aviators
barbarous1345623barbarous
barnstorm1343943barnstorm
barnstorms1442963barnstorms
barrackers1843763barrackers
barracks1636883barra_cks
barracoon1343303barracoon
barracoons1442983barracoons
barrages11711093barra_ges
barrancas1345093barrancas
barrancos1344203barrancos
barratries1245733barratries
barretry13115183barret_ry
barrets94917103barret__s
barrettes1149063barrettes
barriers104311893barr_iers
barrios9310773barr_io_s
barristers1244733barristers
barrooms1237903barr_ooms
barrows123411693barr__ows
barters94223053ba_r_ters
barytons1345573ba_rytons
burritos1044483burrito_s
castrators1247453castrators
caveators1497263caveators
creators102814413_creators
curators10311723_curators
deaerators11107713deaerators
farragoes1344633farragoes
garroters1055823garroters
gyrators1246003_gyrators
hydrators1645683hydrators
labradors1243793labradors
laudators1045893laudators
macerators14167483macerators
mandators1247873mandators
marcatos1249163marcato_s
marranos1038423marrano_s
migrators1247543migrators
narrater838723narrater_
narrates8312763narrat_es
narrations1038943narrations
nitrators949213nitrators
obturators1244303obturators
operators11410753operators
orators7313823__orators
palpators1346803palpators
paradors113411903pa_radors
parroters1156773parroters
perorators1249353perorators
radiators1049333radiators
sartors7314973sa_r_tors
saturators1046093saturators
tarragons1044483tarragons
titrators948383titrators
valuators1286473valuators
varactors1446413varactors
varistors1246533varistors
vibrators14237253vibrators
warranters1344543warranters
warrantor1243213warrantor_
warriors1135363warr_iors

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 Limit148641816.50022867.8
3Display Results81810.0461760.9
 (SQL Overall)178691816.96625651.9
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.