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 “inflow” 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
inflow123529(None) 
inflows1335521inflows
airflow1343542airflow
flow105924922__flow
indow95011662in_dow
influx1643722influx
info75617352inf_o_
infold10128162infold
infos84311672inf_os
reflow12379652reflow
upflow1433522upflow
aglow94711963_aglow
airflows1443833airflows
airglow1143663airglow
allow85420663_allow
alow75328593__alow
analog7159963analog
anglo65215363anglo_
anglos74413903anglos
anyhow1544103anyhow
barlow112911423barlow
bellow114213353bellow
below104617193_below
billow114111223billow
blow95827193__blow
callow114714663callow
endow94510983en_dow
enfold10137613enfold
enow77819873en__ow
fallow124713853fallow
fellow123712743fellow
finfoot1347173finfoot
flaw106326643__flaw
flew105824253__flew
floc95922123__floc
floe76129773__floe
flog85523893__flog
flop96925453__flop
flown116213993__flown
flows115822363__flows
follow124010353follow
frow106425053__frow
glow85222523__glow
hallow124818323hallow
hollow124212663hollow
igloo6410493i_gloo
inclip1036823inclip
inclose9910223inclose
incog838253in_cog
indol63714873in_dol
indole74516053indole
indols74714203indols
indoor738403indoor
indows104210793in_dows
infall939403infall
infalls1038943infalls
infamy1435643infamy
infant92315133infant
infare9313083infare
infect113413443infect
infeoff1253263infeoff
infer84215033inf_er
infers93615443infers
infest93315433infest
infill938403infill
infirm1137033infirm
infix15337763inf_ix
inflame1256963inflame
inflate10312313inflate
inflator1158033inflator
inflect1249223inflect
inflict1248623inflict
infolds11137023infolds
inform11310153inform
infra838643inf_ra
infuse93110573infuse
ingle64120433ingl_e
ingles74420873ingles
ingot61221063in_got
ingrown1145393ingrown
inion54620173in_ion
inkblot1344203inkblot
inkle94515833inkl_e
inkles103515653inkles
inkpot1237813inkpot
inlay85214323in_lay
inlet53732403in_let
inly75622213in_l_y
inro45920793in_ro_
insole63515863insole
interflow1544633interflow
into45026153in_to_
intown936153in_town
intro54915853intro_
intron64215023intron
intros64215773intros
inulin6311733inulin
isolog737403isolog
kinfolk1363603kinfolk
know116115843kn__ow
linalol745093linalol
low66051873___low
mallow114014743mallow
mellow114112223mellow
minnow1135583min_now
mudflow1642333mudflow
nohow1137293_nohow
nolo46229313_nolo_
nolos54423353_nolos
now65950193_n__ow
nylon82910513_nylon
outflow1355353outflow
pillow113110573pillow
pinfold1336233pinfold
plow95923233__plow
reflew12389453reflew
reflown13316213reflown
reflows13258983reflows
reglow10339403reglow
replow114210343replow
sallow94315753sallow
slow77729493__slow
snow76324793sn__ow
sunglow1143943sunglow
tallow93714203tallow
teflon937453teflon
unclog956603unclog
unfold10179703unfold
upflows1543513upflows
wallow123913513wallow
willow12369693willow
windflaw1842293windflaw
window1347363win_dow
windrow1445853windrow
wingbow1643773wingbow
winnow1234593win_now
yellow12429883yellow

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 Filter1786911127160.1561145455.1
2DLD Change Limit1127161378.87612699.0
3Display Results1371370.0462978.3
 (SQL Overall)1786911379.07819684.0
 
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.