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

93 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
operators1141075(None) 
operator10310091operator_
aerators8315612_aerators
cooperators1547002cooperators
imperators1447712imperators
moderators1386642moderators
operagoers1342762operagoers
operates10515412operat_es
operatics1346952operatics
operations12312952operations
orators7313822o__rators
tolerators1046732tolerators
aerator7314843_aerator_
aspirators1247003aspirators
barrators1148393barrators
chelators1448163chelators
cocreators1447133cocreators
cocurators1447303cocurators
comparators1785683comparators
cooperator1446833cooperator_
corporators1546653corporators
creators102814403cre_ators
cremators1369803cremators
curators10311723_curators
deaerators11107713deaerators
delators92314823_delators
depurators1346483depurators
elevators1246303elevators
enervators1345703enervators
epilators1149433epilators
evertors1138953ever_tors
execrators1946023execrators
federators1446193federators
generators1147533generators
gyrators1245993_gyrators
heritors11310903_heritors
hydrators1645683hydrators
imperator1347783imperator_
legators92811033_legators
levators11249283_levators
liberators1247013liberators
literators1048103literators
macerators14167483macerators
migrators1247543migrators
moderator12106543moderator_
moderatos1286523moderato_s
narrators947863narrators
negators92411173_negators
nitrators949213nitrators
numerators1245553numerators
obturators1244303obturators
obviators1444843obviators
operagoer1242773operagoer
operands1146813opera_nds
operants1039483opera_nts
operas8312453opera___s
operate9615733operat__e
operated11512223operat_ed
operatic1249933operat_ic
operating12313723operating
operation11314003operation
operative141110553operative
operatives15117883operatives
operatorless1461893operatorless
operettas1143323operettas
operons91411743oper__ons
orator6314533o__rator_
oratory1039403o__ratory
overeaters1348633overeaters
overfavors1942383overfavors
overlabors1543223overlabors
overstirs1238213overstirs
overstory1546143overstory
overtops1338513over_tops
overwaters1645753overwaters
oviraptors1542223oviraptors
paradors113411903_paradors
permeators1447403_permeators
perorators1249353_perorators
praetors1039833_p_raetors
praters94921653_p_raters
predators12310083predators
pretors9316803_p_retors
relators83316123_relators
senators8312953_senators
separators1246503separators
spectators1444533spectators
stertors8310923ster_tors
superatoms1448393superatoms
titrators948383titrators
tolerator956753tolerator_
venerators1347063venerators
vibrators14237253vibrators

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 Filter1786911486410.1561145455.1
2DLD Change Limit148641937.81319024.8
3Display Results93930.0462021.7
 (SQL Overall)178691938.01522294.6
 
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.