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

80 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
maybird154399(None) 
jaybird2043121jaybird
maybirds1643321maybirds
catbird1235242catbird
fatbird1344032fatbird
jaybirds2142822jaybirds
ladybird1542152ladybird
babied114913513ba_bied
bayard124411663bay_ard
bird76128323___bird
boobird1235233boobird
caird85717233ca__ird
catbirds1344203catbirds
cowbird1534433cowbird
daybed13438673dayb_ed
fatbirds1443413fatbirds
gabbard1336553gabbard
gambir11509773gambir_
gambirs12359083gambirs
halberd1336053halberd
hangbird1543223hangbird
hayward1736413hayward
haywire1644743haywire
hybrid15237813_hybrid
jabiru15125513ja_biru
jailbird1842703jailbird
ladybirds1642103ladybirds
laird65417793la__ird
madeira1045103madeira
maftir1136493maftir_
maftirs1236043maftirs
maid75537663ma__i_d
mair66133783ma__ir_
mairs76228303ma__irs
mallard10310273mallard
mamboed14417623mamboed
mankind1437773mankind
mansard1049313mansard
mantid93820383manti_d
manward1349093manward
marbled123212113marbled
married104715303married
masjid16187323masji_d
maybe12311133mayb__e
maybes1339243mayb_es
maybush1742453maybush
mayed115522403may__ed
maying124421153may_ing
mayor106616623may_or_
mayors115714193may_ors
mayvin1436523mayvi_n
mayvins1535323mayvins
mayweed1634163mayweed
mazard1838763ma_zard
mazzard1844463mazzard
mbira977973m__bira
misbind1258273misbind
morbid112511463morbi_d
myoid11512993m_yoi_d
myriad1235913m_yriad
mysid11610693m_ysi_d
oilbird1043743oilbird
rabid84520783ra_bi_d
railbird1143443railbird
rainbird1143143rainbird
redbird1155263redbird
sabir75917003sa_bir_
sabirs85414633sa_birs
sayid95516723say_i_d
sayyid13185353sayyi_d
seabird1055363seabird
sunbird1044743sunbird
tabard9313333ta_bard
tabbied12297793tabbied
tabid84418263ta_bi_d
waybill1543723waybill
wayward1736053wayward
yaird96111913__yaird
yardbird1542323yardbird
yird87018983__y_ird

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 Limit134027806.48320673.6
3Display Results80800.0332424.2
 (SQL Overall)178691806.92225814.9
 
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.