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

65 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
sunbirds114390(None) 
sunbird1044741sunbird_
seabirds1164402seabirds
songbirds1342772songbirds
sunburns1044282sunburns
sunwards1236442sunwards
surfbirds1542162surfbirds
unbinds10267352_unbinds
ungirds9105302_ungirds
birds85421333___birds
bluebirds1442963bluebirds
boobirds1344183boobirds
catbirds1344203catbirds
cowbirds1644043cowbirds
engirds995053_engirds
fatbirds1443413fatbirds
gunfires1235063gunfires
hangbirds1642933hangbirds
jaybirds2142823jaybirds
kingbirds1782523kingbirds
maybirds1643323maybirds
moundbirds1651643moundbirds
oilbirds1143183oilbirds
outbids1098913outbi_ds
ovenbirds1542023ovenbirds
rainbirds1242863rainbirds
redbirds1283873redbirds
sabirs85414633s_abir_s
santirs7312963santir_s
seabird1055363seabird_
shairds11216263s_hairds
snowbirds1542953snowbirds
songbird1243233songbird_
subbings13238483subbings
subers85722643su_ber_s
suborns939493su_borns
suburbs1136503su_burbs
subvirus1344333subvirus
sulfids1137293sulfi_ds
sunbaths1344383sunbaths
sunbeams1243963sunbeams
sunbelts1044673sunbelts
sunbows1236023sunb_ows
sunburn945133sunbur_n
sunburnt1045603sunburnt
sunburst1045183sunburst
sunbursts1143033sunbursts
sunders84120053sunder_s
sundials946753sundials
sundries9312023sundries
sunlands936383sunlands
sunrises8310693sunrises
sunward1137653sunward_
surds65624663su___rds
surfbird1442593surfbird_
suspires1038203suspires
unbars82113033_unbar_s
unbends10236993_unbends
unbid83214643_unbi_d_
unbind93011433_unbind_
unbuilds1143153_unbuilds
ungird887973_ungird_
unwinds11286733_unwinds
upbinds12234813_upbinds
upgirds11103073_upgirds

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 Filter1786911461620.406440125.6
2DLD Change Limit146162658.01618233.8
3Display Results65650.0302166.7
 (SQL Overall)178691658.45221141.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.