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 “nullity” with Change Limit: [1] [2] [3]

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

137 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
nullity103736(None) 
nullify1334711nullify
duality1147972duality
jollity1746142jollity
mullite9313012mullite
nubility1347792nubility
nudity1037992nu_dity
nulling83818062nulling
quality1938562quality
ability12311443ability
agility1148653agility
anality10313633anality
anility10312723anility
aurality1139223aurality
bulkily16227123bulkily
bullate93415073bullate
bullet84528613bullet_
bullets93516393bullets
bullied104514813bullied
bullier94116433bullier
bullies94121893bullies
bulling104324793bulling
bullion91911033bullion
bullish12511193bullish
bully105124813bull__y
burlily1237713burlily
cullay113910173cull_ay
cullet84727313cullet_
cullets94015613cullets
cullied104012353cullied
cullies94419963cullies
culling103921303culling
cullion91910233cullion
cullis84115993culli_s
cully105520463cull__y
curlily1238383curlily
dulcify1643023dulcify
dulling93418273dulling
dullish1148743dullish
dully94921633dull__y
equality2046993equality
falsity1335913falsity
fullery13337973fullery
fulling114019703fulling
fully114820863full__y
furmity1535193furmity
futility1446983futility
guilty10418233guil_ty
gullet74924833gullet_
gullets84013713gullets
gulley104213163gull_ey
gullibly1443473gullibly
gullied93812063gullied
gullies84717313gullies
gulling94019563gulling
gully94020683gull__y
gulosity1244443gulosity
hulling113619013hulling
humility1646103humility
illite63414923_illite
inutility1246223inutility
jellify2054553jellify
jollify2044263jollify
jollily1745773jollily
laity85318903__laity
lullaby1243363lullaby
lulling83616803lulling
molality13118363molality
mollify1555503mollify
mullet84126823mullet_
mullets93614783mullets
mulley114013453mull_ey
mulling103819993mulling
mullion91911173mullion
mullites10411643mullites
nasality1146653nasality
natality1139193natality
nellie63614813nelli_e
nellies73418723nellies
nelly84618813nell__y
neolith1068783neolith
nihility1446213nihility
nilling83619563nilling
nobility1348983nobility
nodality12127423nodality
nuclide1037173nuclide
nuggety1234313nuggety
null45125313null___
nullah9388143null_ah
nullahs10316993nullahs
nulled74318273null_ed
nullities949353nullities
nulls55019983null__s
nunlike11258073nunlike
nurling84215823nurling
nutlet64220563nutlet_
nutlets74111253nutlets
nutlike113110113nutlike
nuttily10308633nuttily
nutty84816873nu__tty
orality101111683orality
outcity1238453outcity
outpity1237493outpity
ovality1377593ovality
polity113015863_polity
pullet84026333pullet_
pullets94015163pullets
pulley113713403pull_ey
pulling103821073pulling
pulpily1436103pulpily
pulpit10310933pulpit_
pulpits1137243pulpits
purity114114913pu_rity
qualify2235473qualify
reality10313573reality
rurality1137403rurality
sillily10209783sillily
suavity1336323suavity
sulfite10310473sulfite
sulkily14218113sulkily
sullied83714483sullied
sullies74122233sullies
sully84622903sull__y
sunlit61516103sunlit_
surlily10310003surlily
tallit63422733tallit_
tallith102913063tallith
tallits73215993tallits
tillite7313563tillite
uglify1333913_uglify
uglily1036193_uglily
unity84918493_u_nity
unlit55025463_unlit_
uplit76020803_uplit_
uppity1335103_uppity
utility1038713utility
velleity1443743velleity

Search took 8 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.423422437.4
2DLD Change Limit1340271377.34318252.3
3Display Results1371370.0632174.6
 (SQL Overall)1786911377.82922824.2
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.