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

171 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
inpour83706(None) 
inpours936411inpours
incur72212252in_cur
indoor738402indoor
inpoured1135812inpoured
input7314652inp_ut
insoul638462insoul
pour611527472__pour
repour8310992repour
sapour83812372sapour
vapour11378872vapour
amour75014853_amour
arbour84211323arbour
ardour74110893ardour
armour84411853armour
candour104210233candour
clour76617283_clour
colour85915083colour
contour939963contour
copout10418773copout
detour778193detour
devour1076703devour
dolour75710133dolour
dour56330433__dour
downpour1443003downpour
dyvour1393343dyvour
enamour945433enamour
ensoul638253ensoul
favour12438333favour
flour84916453_flour
four76226863__four
giaour735363giaour
honour94710863honour
hour75827313__hour
humour11116753humour
ichor1039473icho_r
igneous835773igneous
impair1035993impair
impious1137053impious
impone103011853impone
import102713753import
impose103113043impose
imposer113310103imposer
impost103011773impost
impound1235393impound
impower14247123impower
impure1038373imp_ure
inaner62213533inaner
inboard1037063inboard
inborn8319123inborn
inbound10115773inbound
incher114114033incher
incog838253inco_g
incogs937903incogs
income10712093income
incomer1169933incomer
incony1139073incony
incurs83012273in_curs
incus73315053in_cus
indium939493indium
indol63714873indo_l
indole74516053indole
indols74714203indols
indoors838553indoors
indow95011663indo_w
indows104210793indows
indue63516673in_due
infer84215033in_fer
influx1643723influx
info75617353info__
infold10128163infold
inform11310153inform
infos84311673info_s
ingot61221063ingo_t
ingots7912063ingots
ingroup1044333ingroup
inhaul936803inhaul
inion54620173inio_n
inions64417003inions
injure133410863in_jure
injury16266143in_jury
inker94421093in_ker
inkier104013773inkier
inkpot1237813inkpo_t
inkpots1335173inkpots
inlier63615353inlier
inmost8411363inmost
inner54920623in_ner
inpouring1236393inpouring
inputs837703inputs
inro45920793inro__
inroad737933inroad
inrun52911373in_run
insofar1043543insofar
insole63515863insole
insouls737213insouls
instar6310013instar
insure63416603in_sure
inter55028493in_ter
into45026153into__
intomb1036403intomb
intone61115423intone
intoner7811663intoner
intort6418923intort
intown936153intown
inturn63411563in_turn
inure54119053in__ure
inurn53712863in__urn
invar839513in_var
invoke1336213invoke
invoker1435353invoker
inwound11134973inwound
inwove12167273inwove
iodous7311493iodous
knaur9508253kn_aur
knout95018263kn_out
knur85311973kn__ur
labour84210933labour
lour45430683__lour
lupous849433lupous
minor74920063min_o_r
nipper103715713nipper
noir46722433_n_oir
nonpoor956483nonpoor
nor38048823_n_o_r
noun45724183_n_oun
nous46136983_n_ous
odour64710473_odour
our36042893___our
outpour937413outpour
pandour10408213pandour
poor65630223__poor
pouf95732643__pouf
pours74623183__pours
pout65752553__pout
pur56840553__p_ur
rancour987133rancour
repours9310223repours
rigour7258023rigour
rumour8127373rumour
santour737373santour
sapor75119253sapo_r
sapours93610613sapours
savour94110703savour
scour75315533_scour
sinuous739063sinuous
snout54530633sn_out
sopor74016493sopo_r
sour45935893__sour
spoor75016353_spoor
spout75029633_spout
spur65321193_sp_ur
stour54916743_stour
tabour84011313tabour
tenour62610733tenour
tinpot8312513tinpo_t
tour45530373__tour
tumour8137393tumour
undoer73113043undoer
unmoor836313unmoor
unplug954413unplug
unpure82911533unp_ure
valour93010373valour
vapor104013093vapo_r
vapours12277453vapours
vapoury15284803vapoury
velour9328763velour
vigour10256803vigour
vinous93914173vin_ous
your78623433__your
zincous1837053zincous

Search took 6 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 Filter1786911127160.1261418182.5
2DLD Change Limit1127161715.20321663.7
3Display Results1711710.0463717.4
 (SQL Overall)1786911715.37533244.8
 
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.