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

108 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
gradient1031037(None) 
gradients1145271gradients
gladiest101710332gladiest
gradin83517482gradi_n_
gradine93317032gradi_ne
gradines103615252gradines
grading103918712gradi_ng
gradins93416232gradi_ns
grapiest112211922grapiest
grodiest10310552grodiest
radiant82817132_radiant
advent102613753__advent
ardent73022613ar_d_ent
audient8312303_audient
beadiest113815533beadiest
brakiest143912243brakiest
cadent94120353_cad_ent
craziest19319923craziest
credent10313973cred_ent
eradicant1246933eradicant
erodent8313823erod_ent
fragment1448373fragment
gadget93616173g_adge_t
gamiest102816223g_amiest
gardant9314463gard_ant
garden84215083gard_en_
gardens93312093gard_ens
garment10315233g_arment
gaudiest1039393gaudiest
giddiest11298553giddiest
gladden10376313gladden_
gladdens11364463gladdens
gladdest11145843gladdest
gladier93810993gladie_r
gladliest1135373gladliest
glariest92012523glariest
glaziest18227913glaziest
goading103112853goadi_ng
grabbiest1435323grabbiest
graben9419723gra_ben_
grabens10367003gra_bens
gracing113216443graci_ng
grade75126093grad_e__
graded94919553grad_e_d
grader84919693grad_e_r
graders94715993grad_ers
grades84926313grad_e_s
graduand1143893graduand
grain65126253gra_i_n_
grained93814273gra_ined
grainer83714063gra_iner
grainiest10188993grainiest
grains74223093gra_i_ns
grainy103914213gra_i_ny
grandaunt1144703grandaunt
grandest10311573grandest
grant64840023gra___nt
grapier103712603grapie_r
grassiest10309513grassiest
gratin74520583grati_n_
gratine84719193grati_ne
gratinee93710783gratinee
grating93923183grati_ng
gratins84119183grati_ns
graven104513523gra_ven_
gravest114011633gra_vest
gravies11314093gravie_s
graving123114563gravi_ng
grayest11489363gra_yest
graying124115883grayi_ng
grazier173611133grazie_r
graziers18387123graziers
grazing183514553grazi_ng
greasiest10208563greasiest
greediest1147553greediest
griding103014973gridi_ng
grimiest11299823grimiest
gripiest11289633gripiest
grodier939673grodie_r
hardiest123416333hardiest
hardiment1546063hardiment
headiest123015553headiest
ingredient1254373ingredient
irradiant1044913irradiant
lardiest93813883lardiest
leadiest93314983leadiest
obedient1176463obedient
orient6322533or__ient
patient9617073_patient
prudent10310433prud_ent
prurient1048233prurient
raciest92820013_raciest
radian74117273_radian_
radians83013823_radians
radiants9259443_radiants
raiment9315413_raiment
randiest93418773_randiest
readiest93719043readiest
rident7520193_rid_ent
rodent7519243_rod_ent
rudiment1147663_rudiment
salient7419763_salient
sapient9415333_sapient
shadiest121711273shadiest
tardiest93515243tardiest
trading93517973tradi_ng
transient9713213transient
trident8314193trid_ent

Search took 10 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.186960704.3
2DLD Change Limit1461621088.97016294.5
3Display Results1081080.0462347.8
 (SQL Overall)1786911089.20219418.7
 
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.