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

120 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
purins8372265(None) 
burins84221891burins
purin75527591purin_
purine85321891purine
purines94420761purines
puris75332021puri_s
purlins93415421purlins
auris55331532auri_s
auxins13129812auxins
brins75533972_brins
bruins86014952bruins
burans85019302burans
buries84633272buries
burin75626062burin_
burns74926782bur_ns
cumins103314932cumins
curies84934022curies
curing94824782curing
curios83218332curios
curns74924282cur_ns
cutins83919982cutins
durians839572durians
during84419402during
durions839962durions
durns64819872dur_ns
furans94515952furans
furies95126372furies
grins65427222_grins
juries134120632juries
lupins84514462lupins
luring73820752luring
mirins83918902mirins
mucins102712512mucins
mureins9310732mureins
murids93212192murids
murine84220022murine
murines93718222murines
muring95120372muring
pains75138282p_ains
parians93519732parians
paries84742512paries
paring94236492paring
parings104219212parings
paris75145942pari_s
patins87528782patins
paulins9312612paulins
pavins114919662pavins
peins76128062p_eins
pekins121812232pekins
perils84121852perils
peris75537072peri_s
pins65558452p__ins
pirns76020092pir_ns
plains85019592plains
poring94227272poring
porns75527342por_ns
pouring103115862pouring
pries74339532p_ries
prigs85219702p_rigs
prims95425932p_rims
prink114719672p_rink
prinks124315382p_rinks
print74837462p_rint
prints84320102p_rints
prions84317782p_rions
priss74623892p_riss
pterins9812992pterins
pubis94616472pubi_s
puffins15278912puffins
puking133913062puking
puling93621402puling
pulings103511322pulings
pulis74225602puli_s
punkins133111112punkins
puns66641482pu__ns
pupils10389912pupils
purana8712932purana
puranas9712642puranas
purdas92612262purdas
purees84721682purees
purges94421762purges
purging113314182purging
purgings12347292purgings
puri65931442puri__
purify14399152purify
purism104715062purism
purisms114110832purisms
purist85525052purist
purists94014072purists
puritans1037632puritans
purity114114912purity
purlin83615862purlin_
purline93516532purline
purlines103514052purlines
purling103620292purling
purlings113910282purlings
purloins1077032purloins
purls74723352pur_ls
purring104515822purring
purrs75320432pur_rs
purs65641042pur__s
purses84826372purses
pursing103715552pursing
putons83515152putons
pyins105815862p_yins
pyrans11411062pyrans
pyurias1236712pyurias
quins144819852qu_ins
quoins154110582quoins
rins46153192__rins
ruins55822032ru_ins
rutins63818392rutins
sarins63932622sarins
serins64029672serins
spurns84811382spur_ns
turions7311572turions
turns55623242tur_ns
urine55026602_urine
urines64724122_urines
urns46323902_ur_ns

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.343520965.0
2DLD Change Limit825511202.40634310.5
3Display Results1201200.0304000.0
 (SQL Overall)1786911202.77964300.5
 
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.