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

123 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
gratinee9371078(None) 
gratine84719191gratin_e
gratineed11334471gratineed
gratinees10307321gratinees
gradine93317032gradin_e
gradines103615252gradines
grained93814272gra_ined
grainer83714062gra_iner
gratin74520582gratin__
grating93923182gratin_g
gratings103910762gratings
gratins84119182gratin_s
matinee92415612_matinee
ratine65131822_ratin_e
ratines75328582_ratines
trainee72817792tra_inee
brained103816103bra_ined
crating103725203cratin_g
creatine103417413creatin_e
creatines112814433creatines
detainee92511723detainee
drained93713253dra_ined
drainer83012843dra_iner
examinee17156583examinee
gained84617463g_a_ined
gainer74117493g_a_iner
galilee8312213g_alilee
gamine94620153g_amin_e
gamines103618463g_amines
gating84826953g_atin_g
gatings95212823g_atings
gelatine93213303gelatin_e
gelatines102910533gelatines
goatee73219533goat__ee
gracile102512603graci_le
graciles112511613graciles
gracing113216443gracin_g
gradient10310373gradient
gradin83517483gradin__
grading103918713gradin_g
gradins93416233gradin_s
grafting13319623graftin_g
grain65126253gra_in__
grainers93012073gra_iners
grainier9218903gra_inier
grains74223093gra_in_s
grainy103914213gra_in_y
grandee93115513gra_ndee
grange83716203gra__nge
granite82017083grani_te
granites92116363granites
grannie8310353gra_nnie
grannies9312613grannies
grantee83217133gra_ntee
granting103514523grantin_g
grapier103712603grapi_er
grapiness1238253grapiness
grapline1138723graplin_e
graplines1237353graplines
grapnel1035603gra_pnel
grate64932883grat___e
grated84523923grat__ed
grater74625443grat__er
grates75429893grat__es
graticule1254573graticule
gratified1446253gratified
gratifier1345823gratifier
gratifies1347993gratifies
gratify1436113grati_fy
gratineeing1351673gratineeing
gratingly1437403gratingly
gratis74819243grati__s
gratitude11134013gratitude
gravidae13324793gravidae
gravies11314093gravi_es
graving123114563gravin_g
graying124115883grayin_g
grazier173611133grazi_er
grazing183514553grazin_g
grazings19337263grazings
greatened1144583greatened
groined92710813gr_oined
guanine8810543guanin_e
guanines989773guanines
gyrating1337453gyratin_g
isatine7311763isatin_e
isatines8310663isatines
martinet10319643martinet
matinees102110423_matinees
orating83520323oratin_g
patinae95414403_patinae
patine85328123_patin_e
patined105114783_patined
patines95225763_patines
praline93019743pralin_e
pralines102217723pralines
prating103424453pratin_g
pratique19134283pratique
rained75024603_ra_ined
ranee55438103_ra__nee
rapine85023083_rapin_e
rapines95120863_rapines
ratafee1047523_ratafee
rating74938703_ratin_g
ratings84217413_ratings
rationed9410093_rationed
ratite65022423_rati_te
ratites74920683_ratites
ratline74517803_ratlin_e
ratlines83815293_ratlines
ravine95522223_ravin_e
ravined115411823_ravined
ravines104220233_ravines
retinae75517333_retinae
retine66237333_retin_e
retinene839803_retinene
retines75134673_retines
retinue75414843_retinue
retiree75019083_retiree
satinet7325283_satinet
trained84117203tra_ined
trainees82712063tra_inees
trainer73316793tra_iner

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.440406115.9
2DLD Change Limit1461621237.34319904.9
3Display Results1231230.0462673.9
 (SQL Overall)1786911237.82922824.2
 
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.