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

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
nonwork144842(None) 
nonword1149151nonword
ironwork15125062ironwork
network1446802network
nonbook1346282nonbook
noncore9411952noncore
nonwar9159422nonwar_
nonwars10109002nonwars
nonwool1046672nonwool
nonwords1247462nonwords
nonworker1644822nonworker
pinwork16107242pinwork
tinwork1476992tinwork
topwork1646342topwork
artwork1447093artwork
bodywork2143973bodywork
bonnock1545203bonnock
bywork1834863_bywork
concord12510343concord
condor94616973condor_
condors104018573condors
conform14310463conform
consort91319903consort
contort91422343contort
cutwork16176823cutwork
daywork1845653daywork
donor64418193don_or_
donors75115793don_ors
fanwort13310733fanwort
footwork1845813footwork
formwork2044533formwork
forworn13107793forworn
handwork1946903handwork
homework2045833homework
honewort14410083honewort
honor85718623hon_or_
honors94816793hon_ors
hornworm1645253hornworm
hornwort1447793hornwort
ironworks16114813ironworks
legwork1545663legwork
linkwork1444253linkwork
loanword1244413loanword
lobworm1445253lobworm
moonwort1367813moonwort
networks1546143networks
nonart6319193non_art
nonbank1345903nonbank
nonbody1344823nonbody
nonbooks1446123nonbooks
noncola948293noncola
noncom1039683nonco_m
noncoms1139203noncoms
nonfarm1246513nonfarm
nonfood1156653nonfood
nonhero1057913nonhero
nonhome1248833nonhome
noniron738373noniron
nonjury1744033nonjury
nonmoral1049233nonmoral
nonnetwork1751893nonnetwork
nonoral7313603non_oral
nonpar8168993nonpar_
nonpeak1345473nonpeak
nonpoor956483nonpoor
nonpros937473nonpros
nonstory1148103nonstory
nonwage1137163nonwage
nonwoody1544273nonwoody
nonworkers1744413nonworkers
nonworking1844213nonworking
nonwoven1444633nonwoven
nonzero1646123nonzero
nook85728493no__o_k
onward1039053_onward
openwork1743523openwork
outwork141710353outwork
pinworks17106353pinworks
pinworm1467183pinworm
prework164210913prework
rework136619793_rework
roadwork1645473roadwork
rockwork1644993rockwork
slopwork1743723slopwork
stonework1644093stonework
tinworks1596043tinworks
topworks1745343topworks
uncork1239043_uncork
unworn93411333_unworn
warwork1757583warwork
waxwork24104883waxwork
webwork1944843webwork
woodwork1955933woodwork
woolwork1854693woolwork
work115528843___work

Search took 7 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.406440125.6
2DLD Change Limit134027956.31321230.3
3Display Results95950.0462065.2
 (SQL Overall)178691956.76526414.0
 
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.