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

48 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
birdlife144348(None) 
birdlike1535231birdlike
birdlime1343561birdlime
birdie94013782bird_i_e
birdlimed1542042birdlimed
birdlimes1443092birdlimes
midlife13248302mi_dlife
wildlife1543252wildlife
airlift1048583air_lift
airlike11310333air_like
airline7315033air_line
barnlike1437183barnlike
beadlike15137253beadlike
bedlike14369533b_edlike
berline93716853ber_line
beryline1337083beryline
biblike1536893bi_blike
billie85019173bi_lli_e
bindle94516263bindl__e
birdcage1443513birdcage
birdied11329433bird_ied
birdies104016213bird_ies
birding114014923bird_ing
birdseye1441643birdseye
birkie124110133bir_ki_e
birle75023633bir_l__e
birling104317053bir_ling
boardlike1643313boardlike
bridle94115463bridl__e
bridling122610583bridling
budlike14257873b_udlike
burdie93615023burd_i_e
cordlike1537233cordlike
girdle82110463girdl__e
girdling1146823girdling
girlie73711463gir_li_e
hardline12310273hardline
herdlike1636113herdlike
highlife1843003highlife
kidlike1137063ki_dlike
lardlike1336503lardlike
lordlike1345813lordlike
midlifer14215793mi_dlifer
midline102315103mi_dline
midwife16225523mi_dwife
prelife1279943_prelife
virilize2047743virilize
wirelike15167493wirelike

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 Filter1786911461620.440406115.9
2DLD Change Limit146162487.04620744.0
3Display Results48480.0133692.3
 (SQL Overall)178691487.49923828.6
 
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.