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

95 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
marvy13501403(None) 
marly106925611marly
marry104821691marry
army96624182_army
arty77531312_arty
arvo76023432_arvo
barky145721612barky
barmy125218762barmy
barny105821732barny
carny105822922carny
carry105823782carry
carve106227752carve
cavy125920002ca_vy
curvy136013372curvy
darky136018832darky
davy116015522da_vy
early85324122early
farcy135217092farcy
garvey13127872garvey
gravy125512112gravy
hardy125622062hardy
harpy136418202harpy
harry115322952harry
jarvey19135402jarvey
lardy96119272lardy
larky125218872larky
larva8312482larva
madly115218132madly
malmy124816342malmy
malty106721702malty
mamey125418832mamey
mammy115215162mammy
mangy115021232mangy
manly105022942manly
many95731842ma_ny
mar57965942mar__
mara67444562mar_a
maras75443282maras
marbly134111932marbly
marc87034622mar_c
march125622892march
marcs95726622marcs
mare64759322mar_e
mares76457632mares
margay12310592margay
marge85328332marge
maria75032882maria
mark105138052mar_k
marka114620792marka
marks115933482marks
marl66341612mar_l
marls75535162marls
mars66261862mar_s
marse76231152marse
marsh105320852marsh
marshy14558332marshy
mart66865972mar_t
marts77442232marts
martyr1135692martyr
marvel113712002marvel
mashy136016502mashy
massy104518962massy
matey107022662matey
mauve104013272mauve
may88757622ma__y
mazy186419692ma_zy
mercy125916182mercy
merry104721482merry
mirky146315522mirky
miry96326742mir_y
moray105423792moray
murky145216682murky
murry105120232murry
narky126017802narky
nary76931222nar_y
navvy14696682navvy
navy107518632na_vy
nervy114610862nervy
pardy115523952pardy
parry105323752parry
party106630612party
parve109824852parve
parvo107719182parvo
sarky125521782sarky
savvy14497502savvy
smarmy13629352smarmy
smarty115013792smarty
tardy94720462tardy
tarry85422512tarry
tarty86328182tarty
varve115716852varve
vary105226062var_y
warty119323822warty
wary106740012war_y
wavy136620472wa_vy

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 Filter178691538000.0931921408.6
2DLD Change Limit53800951.87328724.0
3Display Results95950.0332878.8
 (SQL Overall)178691951.99989390.2
 
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.