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

119 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
catbird123524(None) 
catbirds1344201catbirds
fatbird1344031fatbird
caird85717232ca__ird
cowbird1534432cowbird
fatbirds1443412fatbirds
jaybird2043122jaybird
maybird1543992maybird
attire62412383_attire
attired8238913_attired
babied114913513ba_bied
batgirl1043393batgirl
bird76128323___bird
boobird1235233boobird
cabbed135416263ca_bbed
cabbie122913353cabbi_e
cabbies133115163cabbies
cabbing143613153cabbing
caber95126833ca_ber_
cabers105023923ca_bers
cabildo1254723ca_bildo
cabin94820943ca_bi_n
cabined1239993ca_bined
cabins104418923ca_bins
cabled114819873ca_bled
cactoid12311033cactoi_d
caddied123710563caddied
caid77837533ca__i_d
cairds96411513ca__irds
cairn75717513ca__irn
calibre1136603calibre
calibred1335053calibred
camber124418483camber_
cambered15129003cambered
cambers134017443cambers
cambia124913153cambi_a
cambial134010763cambial
cambism1538033cambism
cambist13312113cambist
cambium1537323cambium
cambric1537393cambric
canard9314763ca_nard
candid104517853candi_d
candied113816023candied
canid85526343ca_ni_d
capsid11312413capsi_d
carabid12311333carabi_d
carbarn1139453carbarn
carbide126112493carbide
carbine112918643carbine
carbora11310703carbora
card710245873ca___rd
caried94528693ca_ried
carried103717153carried
catarrh1245013catarrh
catboat11412243catboat
catbrier1236173catbrier
catbriers1344143catbriers
cater74840723cat_er_
catered103117773catered
caters85336503cat_ers
catfish1559023catfish
cathead1338753cathead
cation83925503cat_ion
catkin123512383catki_n
catkins133012563catkins
catlike132712933catlike
catlin83819083catli_n
catling104819793catling
catlins93818843catlins
catmint11314463catmint
catnip1097973catni_p
catnips1195893catnips
catted95422473cat_ted
cattery123811603cattery
cattie85221023catti_e
cattier93317073cattier
catties94023053catties
cattily123210853cattily
catting103922643catting
cattish12410723cattish
cebid104314073c_ebi_d
cedarbird1571423cedarbird
citied94014143cit_ied
cowbind1536613cowbind
cowbirds1644043cowbirds
gabbard1336553gabbard
gambir11509773gambir_
gambirs12359083gambirs
halberd1336053halberd
hangbird1543223hangbird
hatband1346823hatband
heathbird18122513heathbird
jabiru15125513ja_biru
jailbird1842703jailbird
jaybirds2142823jaybirds
ladybird1542153ladybird
laird65417793la__ird
maybirds1643323maybirds
oilbird1043743oilbird
outbid91411863outbi_d
rabid84520783ra_bi_d
railbird1143443railbird
rainbird1143143rainbird
redbird1155263redbird
sabir75917003sa_bir_
sabirs85414633sa_birs
satire63218003sat_ire
satyrid1137233satyrid
scabbard1544203scabbard
seabird1055363seabird
sunbird1044743sunbird
tabard9313333ta_bard
tabbied12297793tabbied
tabid84418263ta_bi_d
third95912493__third
waterbird1554503waterbird
yaird96111913ya__ird
yardbird1542323yardbird

Search took 8 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.403443402.0
2DLD Change Limit1340271197.08018930.4
3Display Results1191190.0462587.0
 (SQL Overall)1786911197.52923733.7
 
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.