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

100 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
grugru84293(None) 
grugrus941991grugrus
grigri833852grigri
guru54623912g_u_ru
augur64311213_augur
brugh115414293brug_h
brughs12509063brughs
cruor7310443cruor_
cruors838623cruors
crura7312583cru_ra
drug65718133drug__
druggy12344743druggy
drugs75214653drug_s
erugo6369853erug_o
erugos7347343erugos
frug86517103frug__
frugal1036393frugal
frugs96114283frug_s
fugu85419863_fug_u
gauge76117903gaug_e
gauged94713473gauged
gauger84714853gauger
gaugers94211703gaugers
gauges85915993gauges
gaur56723353gau_r_
gaurs66317993gau_rs
gluer65116773gluer_
gluers75011153gluers
glug66118013glug__
glugs75214283glug_s
gouge78220063goug_e
gouged96214593gouged
gouger86014363gouger
gougers94911763gougers
gouges86318693gouges
gourd71011903gou_rd
grego7310523greg_o
gregos847533gregos
grig65424773grig__
grigris934093grigris
grigs75318193grig_s
grog65923343grog__
groggy1234803groggy
grogram1147073grogram
grogs76319413grog_s
grub77220083gru__b
grubby14324503grubby
grubs86312603gru_bs
grudge9388583grudge
grudged11317163grudged
grudger10368313grudger
grudgers11266743grudgers
grudges10349423grudges
grue55825713gru__e
gruel66014743gru_el
gruels73910153gruels
grues65721963gru_es
gruff124712143gru_ff
gruffs13337453gruffs
gruffy16396013gruffy
grum75625083gru__m
grume86218163gru_me
grumes94415553grumes
grumous1086603grumous
grump105115313gru_mp
grumps114510573grumps
grumpy14498153grumpy
grunge8359583grunge
grunger9389783grunger
grungers10298503grungers
grunges93310403grunges
grungy11345973grungy
grunt65523543gru_nt
grunts75511853grunts
grutch12285563grutch
gruyere1133123gruyere
guar56923293g_uar_
guard74415543g_uard
guars65021043g_uars
guiro63712093g_uiro
gurge75419783gurg_e
gurged95513363gurged
gurges84716863gurges
gurgle83912473gurgle
gurry94515413g_urry
gurus64318193g_u_rus
kuru85521803_ku_ru
maugre9308973maugre
ruer46127563_ruer_
ruers515019413_ruers
rug46039153_rug__
ruga56121233_rug_a
rugae65114763_rugae
rugal65916093_rugal
rugby11448133_rugby
rugous739643_rugous
rugs56033683_rug_s
truer54916643truer_
trug55720043trug__
trugs65516803trug_s

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 Filter1786911127160.1401276364.3
2DLD Change Limit1127161006.17318259.5
3Display Results1001000.0303333.3
 (SQL Overall)1786911006.34328171.4
 
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.