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

You can choose a higher Change Limit to return more words, although it will take longer.
to automatically increase the Change Limit after seconds.

79 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
guided9401411(None) 
glided94513901glided
grided95117041grided
guide75019881guide_
guider84313521guider
guides84118281guides
guiled84315381guiled
guised84612171guised
abided105313312abided
aided75828932_aided
bided95424962_bided
budded113912332budded
builded1136472builded
chided135113962chided
curded104217162curded
duded84417132du_ded
elided84814672elided
funded114413892funded
gadded103913172gadded
gained84617462gained
gaited84416922gaited
gelded94512112gelded
gibed96215962g_ibed
gied64631982g_i_ed
gilded94413222gilded
girded93712492girded
glide74521592glide_
glider84614262glider
glides84518862glides
glimed105312282glimed
goaded94913712goaded
godded104811802godded
graded94919552graded
gridded11387582gridded
gride75223582gride_
grides84422362grides
grimed104714092grimed
grinded104210632grinded
griped104114712griped
guarded1036152guarded
gude65423332gu_de_
gudes74520812gu_des
guid66022822gui__d
guiders94111112guiders
guidon837372guidon
guids75516152guid_s
guild75312752gui_ld
guilder945912guilder
guile64521132guile_
guiles73919282guiles
guinea737612guinea
guise64717712guise_
guises74216312guises
gulden8328762gulden
gulfed114810012gulfed
gulled84521372gulled
gulped104610372gulped
gummed123811662gummed
gunned83513092gunned
gurged95513362gurged
gushed114816242gushed
gusted84316722gusted
gutted84716362gutted
guyed1049892gu_yed
hided105222442_hided
juiced1636512juiced
loided83414022loided
mudded114511382mudded
nided75920872_nided
prided103618032prided
quired163711952quired
raided85017702raided
ruined74813322ruined
sided74825952_sided
sueded84014632sueded
suited74019422suited
tided76322512_tided
unguided1136232unguided
voided114011132voided

Search took 3 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 Filter178691825510.360496363.9
2DLD Change Limit82551792.33035429.6
3Display Results79790.0136076.9
 (SQL Overall)178691792.70366108.4
 
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.