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 “gruyere” with Change Limit: [1] [2] [3]

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

111 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
gruyere113312(None) 
gruyeres1242861gruyeres
grayer106014542grayer_
greyer104510092greyer_
tuyere9408612_tuyere
brayer115315313brayer_
brayers124511903brayers
buyer105013093_buyer_
buyers114511003_buyers
cruder95612383cruder_
dryer95111463dr_yer_
dryers10449273dr_yers
frere85617723fr__ere
fryer115913433fr_yer_
fryers125710973fr_yers
galere73716673g_alere
gaudery1234743gaudery
gauger84714853gauger_
gaugers94211713gaugers
gayer94519193g_ayer_
gluer65116773glu_er_
gluers75011153glu_ers
gluier7310263gluier_
gouger86014363gouger_
gougers94911763gougers
grader84919693grader_
graders94716013graders
grapery13457953grapery
grater74625443grater_
graters85419743graters
graver105018593graver_
gravers114515273gravers
gravure1134953gravure
grayed115415643graye_d
grayest11489363grayest
grazer164815763grazer_
grazers175112453grazers
grebe85114943gr__ebe
gree56641563gr__e_e
greyed114610603greye_d
greyest11348343greyest
grieve1047243gr_ieve
griper94114613griper_
gripers104011463gripers
grocer94212143grocer_
grocers103511253grocers
grocery13336763grocery
groper94517253groper_
gropers104813853gropers
grouper104210093grouper_
groupers11358643groupers
grouser84513693grouser_
grousers93810733grousers
grouter84412523grouter_
grouters95910083grouters
grower104614933grower_
growers113612723growers
groyne1037213groy_ne
grubber12417913grubber_
grubbers13316203grubbers
grudge9388583gru_dge
grudger10368313grudger_
grudgers11266753grudgers
grue55825713gru___e
gruel66014743gru_e_l
grueled937133gru_eled
grueler837023gru_eler
gruelers936173gruelers
gruels73910153gru_els
grues65721963gru_e_s
gruffer1475793gruffer_
grugru842933gru_gru
grumble12349233grumble
grume86218163gru__me
grumes94415553grume_s
grummer12338783grummer_
grumose1035723grumose
grunge8359583gru_nge
grunger9389783grunger_
grungers10298503grungers
grunter83110783grunter_
grunters9359033grunters
gruntle8257053gruntle
grushie1135813grushie
guyed1049893g_uye_d
gyre84722763g__y_re
prayer114815293prayer_
prayers124212853prayers
preyer114413733preyer_
preyers124412363preyers
prisere9310943prisere
prudery1335243prudery
pruner83413453pruner_
pruners93710723pruners
pryer104415313pr_yer_
pryers115012243pr_yers
quaere154110673_quaere
revere94621253_revere
ruder65320543_ruder_
rudery10419033_rudery
ruer46127563_ru_er_
ruers515019413_ru_ers
ruler54923343_ruler_
rulers64317093_rulers
rupee7321283_rupe_e
trouvere1144073trouvere
truer54916643tru_er_
tuyer85414293_tuyer_
tuyeres10417793_tuyeres
tuyers94612563_tuyers
wryer11489303wr_yer_

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.1561145455.1
2DLD Change Limit1340271116.34321129.9
3Display Results1111110.0462413.0
 (SQL Overall)1786911116.54527301.9
 
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.