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

(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
loupe7531951(None) 
coupe96023481coupe
lope65941921lo_pe
louie55023511louie
loup66028431loup_
louped95316381louped
loupen84510291loupen
loupes84918051loupes
loups75319621loups
louse56131011louse
blouse84714722blouse
boule74828042boule
bouse75931852bouse
cope86847382co_pe
coude85022632coude
coup86729792coup_
couped115019312couped
coupes105022522coupes
couple104415962couple
coups95522472coups
croupe105114432croupe
dope76038892do_pe
douce85518422douce
douse66329722douse
drupe85012992drupe
dupe76630602_dupe
elope75219342elo_pe
gouge78220062gouge
hope96639672ho_pe
house89131422house
joule124918202joule
jupe134921002_jupe
lipe66839732l_ipe
lobe65535362lo_be
lobule82910062lobule
locule83412032locule
lode56240112lo_de
lodge76520082lodge
loge56837192lo_ge
lone45849132lo_ne
longe66626462longe
looie55624242looie
loop67835012loop_
looped95217172looped
looper83817112looper
loops75723962loops
loopy105316642loopy
loose56627682loose
lop58255312lo_p_
loped85128332lo_ped
loper75129232lo_per
lopes76437342lo_pes
lopped114218622lopped
lopper103717202lopper
loppy125911662loppy
lops66043352lo_ps
lore45850352lo_re
lose45144582lo_se
lotte54923852lotte
louche115212662louche
loud55228042lou_d
louden73711792louden
louder74414602louder
lough95118482lough
louies64525102louies
louis57322322louis
louma76213632louma
lounge75211212lounge
lour45430682lou_r
loured74617402loured
lours55125292lours
loury85716752loury
loused74822912loused
louses66230282louses
lousy84617082lousy
lout45952142lou_t
louted74920692louted
louts56330272louts
louver94110392louver
louvre9425682louvre
love75234762lo_ve
lowe75435312lo_we
lowse87219902lowse
lube64731562l_ube
luce65132572l_uce
lude55331642l_ude
luge55531642l_uge
lune47140492l_une
lure45142462l_ure
lute46341012l_ute
luxe115222692l_uxe
mope86838042mo_pe
moue65835572mou_e
mouse77133002mouse
nope65934192no_pe
ope56845242_o_pe
ouph95618372_ouph
ouphe104413262_ouphe
pope85535612po_pe
rope65542912ro_pe
roue45941742rou_e
rouge65423442rouge
roup66627692roup_
rouped95717352rouped
roupet84218342roupet
roups75118902roups
roupy106112712roupy
rouse56634702rouse
route55132072route
slope75823562slo_pe
soup66232912soup_
souped95017672souped
soups75322942soups
soupy106115402soupy
souse56530772souse
stupe75217752stupe
supe65932762_supe
taupe7314162taupe
tope65946382to_pe
toupee8316132toupee
touse55430672touse
troupe84812432troupe
youse85322232youse

Search took 5 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 Filter178691538000.1701051123.5
2DLD Change Limit538001234.03313339.9
3Display Results1231230.1061160.4
 (SQL Overall)1786911234.30941469.3
 
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.