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

89 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
incubus114474(None) 
incubi1035112incub_i
incubuses1343532incubuses
incudes10319522incudes
incurs83012282incu_rs
incus73315052inc__us
incuses93514852incuses
annulus7426613annulus
aucubas1145173aucubas
bubus95115453__bubus
cubes95028163__cubes
cubs85832383__cub_s
iambus10468903i_ambus
ictus7249703i_c_tus
incages103013883incages
incants92012803incants
incases93615973incases
incents92414533incents
incepts11238283incepts
incests92711383incests
inchers123912523inchers
inches114419673inc_hes
incises93414893incises
incites93218483incites
inclips1135963inclips
includes1146023includes
incogs937903inc_ogs
incomes11712373incomes
inconnus1044293inconnus
incross937663incross
incrust949203inc_rust
incrusts1036253incrusts
incubate1238663incubate
incubates1347603incubates
incudal1045863incudal
incult82414773incu_lt
incumber1444553incumber
incumbers1544003incumbers
incur72212253inc__ur
incurious1145693incurious
incurve1236633incurve
incurves1336393incurves
incuse83513573incu_se
incused102911173incused
indabas1045853indabas
induces103611813induces
inducts10259573inducts
indues73515263indu_es
indults8289493indults
infuses102711873infuses
ingulfs1134733ingulfs
inhumes1296883inhumes
injures143111173injures
innocuous1143073innocuous
inoculum1243443inoculum
inoculums1342683inoculums
inputs837703inpu_ts
inruns6359513inru_ns
insculps1243393insculps
insults7268963insults
insures73117263insures
intuits7310313intuits
inturns73210133inturns
inures63318953in_ures
inurns63310983in_urns
jacobus1843173jacobus
loculus9296973loculus
minibus1136343min_ibus
nimbus10377283_nimbus
nocuous946583nocuous
nubs65927143_n_ub_s
oculus8178393_oculus
pinchbug1841483pinchbug
pinchbugs1951243pinchbugs
rubus76415063__rubus
scubas103710223_scubas
sinuous739063sin_uous
snubs75412553sn_ub_s
succubus1443033succubus
uncinus937403uncinus
unctuous1044853unctuous
uncuffs1543143uncuffs
uncurbs1134913uncurbs
uncurls937123uncurls
uncus74014983unc__us
vacuous1237023vacuous
vinculum1542763vinculum
vinculums1642073vinculums
zincous1837053zinc_ous

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 Limit134027896.09321996.9
3Display Results89890.0461934.8
 (SQL Overall)178691896.54527301.9
 
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.