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

77 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
arrestor84764(None) 
arrester839251arrester
arrestors958021arrestors
ancestor1046852ancestor
arrest63722632arrest__
arrested939152arrested
arrestee849442arrestee
arresters948192arresters
arrests73312682arrest_s
attestor845462attestor
barretor1046712barre_tor
abettor956193a_bettor
accentor12106123accentor
acceptor14114893acceptor
addressor1142503addressor
adjustor1643123adjustor
aerator7314843aer_ator
aggressor1142553aggressor
agrestal945653agrestal
agrestic1147923agrestic
airest63825263airest__
alastor739653a_lastor
ancestors1147233ancestors
aristo6414033a_risto_
aristos7312373a_ristos
armrest9310163armrest__
armrests1055383armrest_s
arrear6310253arre__ar
arrestant947323arrestant
arrestees946233arrestees
arresting1038633arresting
arrestive1246753arrestive
arrogator1045253arrogator
asbestos1044353asbestos
assentor865293assentor
assertor865723assertor
assessor843623assessor
assistor844823assistor
attester836503attester
attestors945753attestors
barrator1048403barr_ator
barretors1146243barre_tors
barrister1145733barrister
cabresto1243733cabresto_
cabrestos1343873cabrestos
corrector1347603corrector
creator93714433_creator
digestor10246553digestor
director1147773director
erector93513803_erector
firestorm1444553firestorm
forester11313673forester
harvester1544333harvester
investor11247403investor
narrator847563narr_ator
nestor63713423__nestor
praetor938973prae_tor
pressor93512873_pressor
prester93519623_prester
presto84216203_presto_
prestore104217343_prestore
prestos93716083_prestos
pretor8315743_pre_tor
protestor11178493protestor
quaestor1743313quaestor
questor16146633_questor
rarest65725483rarest__
rector84019743__rector
rester63832433__rester
restore75822973__restore
rhetor938063_rhe_tor
stressor875533stressor
thrustor1144123thrustor
trustor7238413_trustor
varistor1146393varistor
warrantor1243213warrantor
wrester102812413_wrester

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.1601116818.8
2DLD Change Limit146162778.28017652.4
3Display Results77770.0302566.7
 (SQL Overall)178691778.47021096.9
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.