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

100 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
ribband124558(None) 
riband9239621ri_band
ribbands1344561ribbands
disband1138242disband
rainband1144662rainband
ribald9209292ri_bald
ribands10208392ri_bands
ribbed114014372ribb_ed
ribbing123111952ribbing
ribbon1036532ribbon_
ribboned1343972ribboned
ribbons1136252ribbons
ribbony1443542ribbony
rimland1035662rimland
roband92310722r_oband
armband1265983armband
band76740903___band
bibbed104712343bibb_ed
bibbing11299613bibbing
bland85320453__bland
brand85124493__brand
brigand1136643bri_gand
browband1643883browband
cribbage1542973cribbage
cribbed14407663cribb_ed
cribbing15276843cribbing
cribbled15305803cribbled
dibbed124713473dibb_ed
dibbing133110893dibbing
dibbled133510843dibbled
disbands1237353disbands
dribbed13326753dribb_ed
dribbing14325883dribbing
dribbled14376593dribbled
fibbed144011553fibb_ed
fibbing15339463fibbing
fribbled16305743fribbled
gabbard1336553gabbard
gibbed124512353gibb_ed
gibbing13339373gibbing
gibbon1135323gibbon_
gibbons1234983gibbons
hairband1444573hairband
hatband1346823hatband
husband1345653husband
inland7310313_inland
island738533_island
jibbed184810563jibb_ed
jibbing19338063jibbing
kibbled16367983kibbled
ligand85011293li_gand
midland1136613midland
misbind1258273misbind
misbrand1346413misbrand
nibbed114311903nibb_ed
nibbing12339553nibbing
nibbled12389073nibbled
piebald1245503piebald
proband122710243proband
rabbin103112303rabbin_
rabbins112811343rabbins
rabbled123514423rabbled
rabboni1144803rabboni
rainbands1244193rainbands
rand55839563r___and
rebind94416933r_ebind
reblend1036653reblend
reboant9315093reboant
reboard10310763reboard
rebound1058583rebound
reland75920433r_eland
remand95618963r_emand
repand95316063r_epand
riant55833153ri__ant
ribalds10236673ri_balds
ribber103515493ribb_er
ribbers113913183ribbers
ribbier1137593ribbier
ribbings13275923ribbings
ribby12419683ribb__y
rimlands1145243rimlands
rind56535603ri___nd
ritard74812083ri_tard
robands10219863r_obands
robbed113415193robb_ed
robbin103611183robbin_
robbing123313213robbing
robbins112811063robbins
rubbed114515083rubb_ed
rubbing123412273rubbing
rubbled124611623rubbled
rubboard1343983rubboard
rumbaed12287493rumbaed
rurban849043rurban_
sideband1245023sideband
trainband1243123trainband
viand9511073vi__and
vibrant12410393vibrant
wideband1544453wideband
wristband1542103wristband

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.1701051123.5
2DLD Change Limit1340271007.91016944.0
3Display Results1001000.0303333.3
 (SQL Overall)1786911008.11022033.4
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.