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

57 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
jaybird204312(None) 
jaybirds2142821jaybirds
maybird1543991maybird
catbird1235242catbird
fatbird1344032fatbird
jabiru15125512ja_biru
jailbird1842702jailbird
ladybird1542152ladybird
maybirds1643322maybirds
babied114913513ba_bied
bayard124411663bay_ard
bird76128323___bird
boobird1235233boobird
caird85717233ca__ird
catbirds1344203catbirds
cowbird1534433cowbird
daybed13438673dayb_ed
fatbirds1443413fatbirds
gabbard1336553gabbard
gambir11509773gambir_
gambirs12359083gambirs
halberd1336053halberd
hangbird1543223hangbird
hayward1736413hayward
haywire1644743haywire
hybrid15237813_hybrid
jabbed184213483ja_bbed
jabber173713643jabber_
jabbered2034433jabbered
jabbers183610583jabbers
jabbing19319413jabbing
jabirus1694573ja_birus
jailbirds1942613jailbirds
jambed184811403jamb_ed
jambing19328533jambing
jassid1467223jassi_d
ladybirds1642103ladybirds
laird65417793la__ird
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 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 Filter1786911340270.1531167915.0
2DLD Change Limit134027578.51615738.3
3Display Results57570.0331727.3
 (SQL Overall)178691578.70220534.5
 
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.