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

124 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
abbacy153662(None) 
abaca95118042a_baca
abaci94718842a_baci
aback134816172a_back
abba810522652abba__
abbas95918642abba_s
abbey125714932abb_ey
abbotcy1642092abbotcy
ambary134010542ambary
cabbagy1744012cabbagy
aba512850953a_ba__
abacas104414723a_bacas
abacus10349763a_bacus
abaft10318063a_baft
abaka114313823a_baka
abamp11310603a_bamp
abas68642083a_ba_s
abase76023483a_base
abash106016513a_bash
abate76627843a_bate
abaya104413173a_baya
abbacies1445483abbacies
abbe87627193abb__e
abbes96723523abb_es
abbess10509773abbess
abbeys13538423abbeys
abbot9318453abb_ot
abbots1039283abbots
abduce1197193abduce
abduct11108543abduct
abeam9316533abea_m
abeyancy1853053abeyancy
abject17137703abject
ablate82219213ablate
ablaut8313263ablaut
ablaze17239833ablaze
ably99725133a_b_ly
aboard9312613aboard
abrade9313053abrade
abreact11310823abreact
abroach1446213abroach
abwatt11410673abwatt
aby810238063a_b__y
agency1237033agency
alack114820063a_lack
alary86123443a_lary
alba68328333alba__
albas75925393alba_s
albata839333albata
allay85620393alla_y
alpaca1047383alpaca
alway116113923alwa_y
ambage11510603ambage
ambari103012173ambari
ambery133811133ambery
ambry123512103amb_ry
ambsace1355963ambsace
angary10311323angary
animacy1446103animacy
anlace82513923anlace
apace94718383a_pace
apiary113910383apiary
ariary94114203ariary
arrack121110253arrack
array86317143arra_y
assay8710283assa_y
ataxy1537313a_taxy
attach11118393attach
attack12148153attack
aubade939223aubade
aviary12338413aviary
away108024223a_wa_y
aweary1237303aweary
baba88828353baba__
babas96325733baba_s
baby116723683__baby
bach116131393__bach
back125535763__back
bay89661643__ba_y
beach124623893_beach
beachy164011253_beachy
beady114719923_beady
beaky146118023_beaky
beamy126218573_beamy
bialy105119323_bialy
black134719073_black
brace95629273_brace
brach126123303_brach
bract96332723_bract
braky145015813_braky
braxy175410893_braxy
bray95232903_bra_y
cabbage1446983cabbage
cabbagey1843213cabbagey
cabbala1367183cabbala
cabby145314563cabb__y
curacy1339593curacy
embay123410603emba_y
fallacy1536433fallacy
fatback1836923fatback
gabbard1336553gabbard
gabbart1248883gabbart
gabby135512953gabb__y
garbagy1444243garbagy
kabbala1584613kabbala
lacy95829633__lacy
legacy1256653legacy
lunacy1136843lunacy
pacy115328683__pacy
papacy1547493papacy
payback2056453payback
piracy1339473piracy
rabbity14266303rabbity
racy95825683__racy
rubace10310173rubace
sabbat10314713sabba_t
sabbath1445393sabbath
sabbats1138633sabbats
spacy125415623_spacy
tabby125213893tabb__y
tambac122210243tambac_
tambacs13219363tambacs
wabbly16348363wabb_ly
yabby15389753yabb__y

Search took 6 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 Filter1786911127160.406440125.6
2DLD Change Limit1127161245.36021029.1
3Display Results1241240.0462695.7
 (SQL Overall)1786911245.81230745.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.