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 “rarebits” 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
rarebits104522(None) 
rarebit948421rarebit_
rabbits11299862ra_bbits
rarefies1138992rarefies
ambits103713413_a_mbits
arenite71017713_arenite
arenites8917123_arenites
armpits1157133_armpits
arrests73312683arre_sts
barbets114915843bar_bets
barbies114519593bar_bies
barbuts11439843bar_buts
bareboats1345843bareboats
barefit1249723barefit_
carabids1338193carabids
carabins12312363carabins
carets85330773care__ts
credits1039973_credits
darbies104216983dar_bies
debits94214503__debits
gambits12399723ga_mbits
habits113014653ha__bits
harelips1345213harelips
orbits84211443_or_bits
ourebis936123ourebi_s
parents93418133pare_nts
paresis93315093paresi_s
paretics122312443paretics
parfaits1346913parfaits
prebids12399883_prebids
probits112712573_probits
rabats83116223ra__bats
rabbets11279423ra_bbets
rabbies113416053ra_bbies
rabbins112811343ra_bbins
rabbis102613163ra_bbi_s
rabbit102914563ra_bbit_
rabbity14266303ra_bbity
rabies85226023ra__bies
ramekins1466113ramekins
ramets83517393rame__ts
rarefied1245913rarefied
rarefier1135353rarefier
rarefiers1244023rarefiers
rareness81112853rareness
rareripe1045113rareripe
rareripes1165353rareripes
rares55247443rare___s
rarest65725483rare_st_
rarifies11311943rarifies
rarities8316333rarities
rarity93615493rar__ity
ravelins113011603ravelins
rebaits9312573__rebaits
rebids94015533__rebids
rebuts84015193__rebuts
recits83621353__recits
reedits8511743r_eedits
reemits9611303r_eemits
refits94017653__refits
remits85622943__remits
rerents73319423rere_nts
resits64725563__resits
turbits969233tur_bits
zarebas1836303zareb_as

Search took 10 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.436409841.7
2DLD Change Limit146162659.28315745.1
3Display Results65650.0302166.7
 (SQL Overall)178691659.74918329.2
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.