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

87 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
ratafee104752(None) 
ratafees1144141ratafees
ratable91717552ratable
ratafia1045772ratafia
carafe115416163caraf_e
carafes125015703carafes
catface1436763catface
datable101714233datable
eatable91717603eatable
falafel1383903falafel
gratinee93710783gratinee
hatable121713963hatable
manatee9317663manatee
matinee92415613matinee
pattee84323383pat_tee
raffle123910703ra_ffle
ragee65432663r__agee
raggee84217603ra_ggee
rakee96031173r__akee
ramate83921683rama_te
ramee74633853r__amee
ranee55438103r__anee
rapparee1245873rapparee
rappee103618673ra_ppee
ratables10159723ratables
ratably121711513ratably
ratafias1145323ratafias
ratal55025113rata__l
ratals64219583rata_ls
ratan53722663rata__n
ratanies8312923ratanies
ratans63819373rata_ns
ratany93411873rata_ny
ratatat7412263ratatat
ratches123620463ratches
ratchet124218333ratchet
rate45458763rat___e
rateable10311443rateable
rated65441383rat__ed
ratel54224883rat__el
rater54943283rat__er
rates55352013rat__es
rathe85821923rat__he
rather94319743rat_her
rathole10312053rathole
ratified12310503ratified
ratifier1139673ratifier
ratifies11313513ratifies
ratify122610043ratif_y
ratine65131823rat_ine
ratines75328583ratines
ratite65022423rat_ite
ratites74920683ratites
ratlike113912353ratlike
ratline74517803ratline
ratted74923343rat_ted
ratteen7329113ratteen
ratten64217383rat_ten
ratter64326313rat_ter
rattier74015593rattier
rattle64717613rat_tle
rattled84012953rattled
rattler74012743rattler
rattles73217303rattles
ravage1039303rava_ge
ravaged1236493ravaged
ravager1136553ravager
ravages1139403ravages
razee145827803r__azee
retable91820403retable
retake104718533reta_ke
retaken113911803retaken
retaker113714313retaker
retakes113718863retakes
retape83917683reta_pe
retaped103814283retaped
retapes93917423retapes
retaste72313133retaste
retaxed153512233retaxed
retaxes143615093retaxes
retiree75019083retiree
rotate63320343rota_te
rotated82715293rotated
rotates72819773rotates
rotifer1036993rotifer
watape11208483wata_pe
watapes12228383watapes

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 Filter1786911340270.1401276364.3
2DLD Change Limit134027877.48617903.7
3Display Results87870.0302900.0
 (SQL Overall)178691877.65623340.0
 
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.