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

75 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
grayout114850(None) 
grayouts1244681grayouts
grayest11489362grayest
grout65330422gr__out
layout9513702_layout
payout11714652_payout
ragout7317182_ragout
tryout9410752tr_yout
about75229083__about
bayou10512363_bayou_
bayous11411143_bayous
breakout1456283breakout
buyout11310103_buyout
carryout1346783carryout
crayon114110003crayo_n
crayons12439233crayons
dropout10410003dropout
freakout1545453freakout
gadabout1245563gadabout
galoot72719153g_aloot
gamut8322983g_a_mut
gavot9321113g_avo_t
gayest104314333g_ayest
ghaut95919433gha__ut
giaour735363gia_our
glamour1065133glamour
glout65925813g__lout
gout56646003g___out
gracious1138593gracious
gradus84411213gra_dus
graft95327203gra__ft
grampus12356313grampus
granola837913granola
grant64840023gra__nt
granum9310913gra_num
grat55651283gra___t
gravest114011633gravest
gray85329893gray___
grayed115415643gray_ed
grayer106014543gray_er
grayhound1762023grayhound
graying124115883graying
grayish1437813grayish
graylag1283113graylag
grayly13287963gray_ly
grays95621333gray__s
greyest11348343greyest
griot65328413gr_io_t
groat65531973gr__oat
grot55942053gr__o_t
group85413923gr__oup
grouts75015613gr__outs
grouty104710983gr__outy
grumous1086603grumous
guyot9314523g_uyo_t
kraut95221403kra__ut
layouts1046483_layouts
mahout11415803_mahout
marabout1249103marabout
payouts1247303_payouts
ragouts838533_ragouts
rainout7314393_rainout
ramous8417103_ramous
rayon83815703_rayo_n
rayons94113343_rayons
readout8615493readout
redout71820253_redout
rout46153283_r__out
rubout8313553_rubout
runout6414873_runout
ryot75528563_r_yo_t
trayful1344583trayful
trout57332573tr__out
tryouts1035293tr_youts
uranous7310723uranous

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.1731032896.0
2DLD Change Limit134027758.50015767.9
3Display Results75750.0631190.5
 (SQL Overall)178691758.73620454.6
 
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.