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

119 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
mavins11511918(None) 
mains75635091ma_ins
matins84527781matins
mavens114312971mavens
mavies114923191mavies
mavin105722951mavin_
mavis105622721mavi_s
mayvins1535321mayvins
pavins114919661pavins
ravins94622561ravins
savins93923131savins
ains46158882_a_ins
amins75534312_amins
avens86419332_avens
avians93711562_avians
avions94114392_avions
ayins85321612_ayins
basins85722762basins
cabins104418912cabins
cains75334302ca_ins
cavies114525002cavies
cavils114014392cavils
caving124822612caving
cavings134712542cavings
covins114618062covins
davens104612912davens
davies105020512davies
davits104012362davits
fagins10513862fagins
flavins1338542flavins
gains65729512ga_ins
gamins94420042gamins
havens124514042havens
having134220372having
kains96125642ka_ins
lapins84520682lapins
laving104623572laving
layins93817652layins
levins94514652levins
macing114221552macing
macons104017242macons
mafias113913572mafias
magians10310752magians
magics115311612magics
maids86327132ma_ids
mails76037772ma_ils
maims96321782ma_ims
main65345502ma_in_
mairs76228292ma_irs
making134823842making
makings145413152makings
maligns1038132maligns
maline84529082maline
malines93625602malines
malkins133311802malkins
mamies104626242mamies
manias84029032manias
manics103919932manics
mans66354532ma__ns
margins103815192margins
marina84623412marina
marinas93519372marinas
marine84230402marine
marines93928012marines
marlins93420472marlins
martins93322062martins
masons83916512masons
matin75132852matin_
mating94832912mating
matings104516202matings
mattins93316142mattins
maven104816892maven_
mavie104722562mavi_e
mavises122812992mavises
mawing124020802mawing
maxims17399672maxims
maxing164817072maxing
maxis145721562maxi_s
maying124421152maying
mayings134410502mayings
mayvin1436522mayvin_
mazing184418972mazing
mirins83918892mirins
movies115118452movies
moving123913282moving
mucins102712512mucins
navies95218622navies
pains75138282pa_ins
patins87528782patins
pavans115715592pavans
pavin105623202pavin_
paving124519742paving
pavings134011632pavings
pavis106422732pavi_s
rains55140232ra_ins
ravens93916882ravens
ravin85624652ravin_
ravine95522222ravine
ravines104220232ravines
raving105128852raving
ravings114614492ravings
rawins95617622rawins
sabins85521972sabins
sains55639972sa_ins
sarins63932622sarins
sasins64923102sasins
satins64930482satins
savin84625082savin_
savine94220282savine
savines104417632savines
saving104724512saving
savings114412952savings
spavins12419322spavins
tains54936322ta_ins
takins105117402takins
wains86930862wa_ins
wavies125019842wavies
waving134018202waving
zayins18409712zayins

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 Filter178691825510.216827273.1
2DLD Change Limit825511197.65610782.5
3Display Results1191190.0801487.5
 (SQL Overall)1786911197.95222471.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.