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

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

101 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
adaptor103494(None) 
adapter1036171adapter
adaptors1145251adaptors
abator84512712aba_tor
adapt81218552adapt__
adapted1135842adapted
adapters1136102adapters
adaption1145642adaption
adapts9107812adapt_s
adepter1036112adepter
adopter1036762adopter
alastor739652alastor
anaphor1245652anaphor
captor104914602_captor
raptor83912822_raptor
abater85518123aba_ter
abators94413083aba_tors
abattoir1042043abattoir
abductor1343563abductor
abettor956193abettor
ablator939843ablator
acceptor14114903acceptor
actor71116073__actor
adagio847673adagio_
adagios945513adagios
adapting1236643adapting
adaptions1245223adaptions
adaptive1445133adaptive
additory1344263additory
adductor1243463adductor
adept81219643adept__
adeptly1344183adeptly
adepts9117103adept_s
adjuror1542893adjuror
adjustor1643123adjustor
adopt81219743adopt__
adopted1136253adopted
adoptee1048413adoptee
adopters1136693adopters
adoption1146083adoption
adopts998083adopt_s
adulator948593adulator
advisor11134163advisor
aerator7314843aerator
alastors8311203alastors
amatol838693ama_tol
amatory1238623ama_tory
anaphora1345113anaphora
anaphors1346633anaphors
anatto6139913anatto_
anattos7138453anattos
apter76120203__apter
auditor837313auditor
avatar937523ava_tar
aviator10229663aviator
awaiter1057443awaiter
cadaster1136903cadaster
cantor85621523_cantor
captors113914983_captors
castor84418533_castor
chantor123710313chantor
chapter144213853chapter
coactor1139123coactor
dafter104813343_dafter
dalton7311273_dalton
dapper114016633_dapper
darter75320363_darter
dater65332313_da_ter
dato56129943_da_to_
datos65222783_da_tos
datto65416423_datto_
dattos74311903_dattos
debtor938333_debtor
doctor938993_doctor
editor738663ed_itor
eductor1035863eductor
enactor938033enactor
exactor1636623exactor
factor11911453_factor
gator64416033_ga_tor
grantor84010933grantor
laptop1076813_laptop
laudator945883lauda_tor
mandator1148183manda_tor
orator6314533ora_tor
palpator1247123palpator
pastor84817483_pastor
praetor938973praetor
radiator949203radiator
raptors94213353_raptors
reactor93011653reactor
realtor73611353realtor
redactor1147023redactor
sapor75119253_sap_or
sartor6313883_sartor
stator64015483sta_tor
tractor9311333tractor
traitor7310123traitor
vapor104013093_vap_or
varactor1345683varactor
viator93211833via_tor

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 Filter1786911340270.406440125.6
2DLD Change Limit1340271016.06322105.7
3Display Results1011010.0303366.7
 (SQL Overall)1786911016.49927495.2
 
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.