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

74 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
orfrays134353(None) 
orfray1234391orfray_
affrays1644062affrays
arrays95311682ar_rays
defrays1436112defrays
frays116920102__frays
ofays11488922o_f_ays
portrays1345292portrays
affray1534973affray_
arras55626133ar_ra_s
array86317143ar_ray_
betrays12127823betrays
bewrays15145113bewrays
brays106723113__brays
comfreys1843333comfreys
corrals93713853cor_rals
defrags1236193defrags
defray1337643defray_
derays105514253_derays
drays95819773__drays
estrays10529403estrays
fays108535363__f_ays
flays116321053__flays
forays124813003_forays
forebays1637263forebays
frags96322173__frags
fraps105620553__fraps
frass85321123__frass
frats86829673__frats
fray105428903__fray_
grays95621333__grays
hoorays13418373hoorays
hurrays13386153hurrays
morays114613883_morays
ofay106416103o_f_ay_
offals1235893o_ffals
offramp1742153offramp
offramps1841653offramps
oilways1334873oilways
okays12609443o__kays
okras94410973o_kra_s
onlays9398713o_nlays
operas8312453opera_s
orals55826483o__rals
orcas75918623or_ca_s
ordeals877993ordeals
oreads73915773or_eads
organs7912913or_gans
orgeats838353orgeats
origans839973origans
orphans1237773orphans
orphreys16132053orphreys
orra46120723or_ra__
orris54516553or_r_is
ospreys1233143ospreys
outlays102610903outlays
outprays13236933outprays
outsays102710403outsays
overlays14239693overlays
overpays16248253overpays
portray1237483portray_
prays105022433__prays
prepays1437483prepays
rays77642353___rays
relays94316753_relays
repays113813973_repays
resays93714153_resays
sprays115913643_sprays
strays96417933_strays
sunrays1037083sunrays
trays85623433__trays
vouvrays1741373vouvrays
wolframs1642673wolframs
workdays1942903workdays

Search took 7 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.406440125.6
2DLD Change Limit134027745.71623447.7
3Display Results74740.0332242.4
 (SQL Overall)178691746.15529031.8
 
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.