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

67 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
outdream114471(None) 
outdreams1243551outdreams
outdreamt1244201outdreamt
outbeam1137972out_beam
outbreak1444772outbreak
outdrag937002outdr_ag
outdraw1136902outdr_aw
outdreamed1443392outdreamed
outdress9137322outdress
outdrew1137142outdre_w
outgleam1153632outgleam
outread82811092out_read
outscream1343112outscream
daydream1542343daydream
dream85120393___dream
onstream1045113onstream
outbeams1236063out_beams
outbleat1048423outbleat
outbrag1036993outbr_ag
outbreaks1544073outbreaks
outbred10311263outbre_d
outbreed1138503outbreed
outcheat1349413outcheat
outdare83113403outdare__
outdared102711513outdare_d
outdares92712463outdare_s
outdoer849273outdoe_r
outdoers937513outdoers
outdoes8313123outdoe_s
outdrags1046583outdrags
outdrank1345433outdrank
outdrawn1245013outdrawn
outdraws1236233outdraws
outdreaming1544233outdreaming
outdrink1346553outdrink
outdrive1236893outdrive
outdrop1036193outdr_op
outdrops1136543outdrops
outdrove1236473outdrove
outdrunk1343473outdrunk
outduel837303outdue_l
outduels945053outduels
outeat62824533out__eat
outerwear1242573outerwear
outgleams1242603outgleams
outgrew1136713outgre_w
outhear10910603out_hear
outlead83311103out_lead
outleap9298293out_leap
outpray12268083outpr_ay
outpreach1642703outpreach
outpreen1046913outpreen
outpress10118183outpress
outran63218893out_r_an
outre53922203out_re__
outreach1346003out_reach
outreads9289003out_reads
outroar739513out_roar
outscreams1442243outscreams
outspeak1454583outspeak
outspread1243503outspread
outswam1246613out_swam
outswear1144793outswear
outwear1097713out_wear
redream10107913_redream
stream84717293_st_ream
undreamt1156543_undreamt

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.436409841.7
2DLD Change Limit146162677.15620425.1
3Display Results67670.0164187.5
 (SQL Overall)178691677.60823487.3
 
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.