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

94 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
nonplay124668(None) 
nonplays1344891nonplays
downplay1742872downplay
gunplay1343232gunplay
nongay10169152non_gay
nonpar8168992nonp_ar
nonpeak1345472nonpeak
nonplayer1444712nonplayer
nonplus936182nonplus
nonpolar1046282nonpolar
onlay84212942_on_lay
airplay1245483airplay
byplay1634193_byplay
comply152810383compl_y
copay126516313co_p_ay
display1336663display
downplays1842503downplays
endplay13103963endplay
fondly13299043fondl_y
foreplay1645673foreplay
gunplays1442713gunplays
hoopla1147633hoopla_
hooplas1239193hooplas
inlay85214323_in_lay
lonely92912463lonel_y
longly10279603longl_y
misplay1436383misplay
nobly105314403no_bl_y
nodally1137913nodally
nodular876703nodular
noily86120993no_il_y
nona46929063non__a_
nonas55126653non__as
nonblack1644303nonblack
nonbody1344813nonbody
nonclass1046243nonclass
noncola948293noncola_
noncolas1048613noncolas
nonfan948293non_fan
nonfat9512183non_fat
nongays11176533non_gays
nonglare946373nonglare
nonjury1744013nonjury
nonleafy1443073nonleafy
nonman8412363non_man
nonmeat9312773nonmeat
nonoily1049543nonoily
nonoral7313593nonoral
nonpagan1144413nonpagan
nonpaid1048073nonpaid
nonpapal1244533nonpapal
nonparty1345543nonparty
nonpast939033nonpast
nonplanar1153573nonplanar
nonplayers1543943nonplayers
nonplaying1644443nonplaying
nonpliant1157883nonpliant
nonpoor956483nonpoor
nonpros937463nonpros
nonslip946553nonslip
nonsolar847073nonsolar
nontax1348413non_tax
nonuple946153nonupl_e
nonuples1056533nonuples
nonwar9159423non_war
nonyl849773nonyl__
nonyls957853nonyl_s
noonday1144603noonday
nopal75517103no_p_al
nopals84914023no_pals
noplace1137393no_place
nosegay1143843nosegay
nosily93712683nosil_y
nounally1146483nounally
novelly1346513novelly
novelty1365173novelty
noway111112843no__way
onlays9398713_on_lays
only75319723_on_l_y
outlay92711793_outlay
outplay12267723outplay
play95928983___play
poplar103611113po_plar
replay113412923_replay
sonly85718053son_l_y
splay105816043__splay
tonally10311373tonally
unlay84613703_un_lay
wordplay1752753wordplay
zonally1938003zonally
zonula1537223zonula_
zonulae1645963zonulae
zonular1656493zonular
zonulas1637023zonulas

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 Filter1786911340270.236757165.3
2DLD Change Limit134027949.10614718.5
3Display Results94940.0332848.5
 (SQL Overall)178691949.37519060.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.