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

164 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
incross93766(None) 
uncross938191uncross
across8312642_across
ancress978612ancress
cross75124502__cross
engross837122engross
inclose9910222inclose
incloses101610532incloses
incogs937902inc_ogs
incrossed1244742incrossed
incrosses1146032incrosses
incrust949202incrust
incrusts1036252incrusts
ingress838652ingress
introns73515022introns
intros64215772intro_s
recross989832recross
anchors123912953anchors
anchos114214893ancho_s
andros7313303andro_s
anurous7311553anurous
bicrons113410473bicrons
coss66143493__c_oss
crass76328043__crass
cress75022833__cress
crocs95722433__crocs
crops96125233__crops
crosse85216303__crosse
crows105727313__crows
dacrons103211033dacrons
dineros83812333dinero_s
dross65418093__dross
enclose999993enclose
encloses10911053encloses
encores9315213encores
encrust947873encrust
encrusts1045283encrusts
enrols61213383en_rols
escrows1235803escrows
gross65421693__gross
ichors11310423i_chors
icons76516493i_c_ons
impress1137773impress
improvs1435003improvs
inarms8410093inar_ms
inbreds10245733inbreds
incages103013883incages
incants92012803incants
incase83615283inc_ase
incases93615973incases
incense92410303incense
incenses102411003incenses
incents92414533incents
incepts11238283incepts
incest82918743inc_est
incests92711383incests
inchers123912523inchers
inches114419673inc_hes
incise83515333inc_ise
incises93414893incises
incisor955323incisor
incisors1095293incisors
incites93218483incites
inclasp1145303inclasp
inclasps1244353inclasps
inclips1135963inclips
inclosed1197613inclosed
incloser10106733incloser
inclosers11155563inclosers
incog838253inc_o_g
income10712093inc_ome
incomes11712373incomes
incony1139083inc_ony
incorpse1244693incorpse
incorpses1345173incorpses
increase1066453increase
increases1157383increases
incrossing1345023incrossing
incubus1144743incubus
incudes10319523incudes
incurious1145693incurious
incurs83012283inc_urs
incurves1336393incurves
incus73315053inc__us
incuse83513573inc_use
incuses93514853incuses
indols74714203in_dols
indoors838553indoors
indorse8108193indorse
indorses968063indorses
indows104210793in_dows
indris7311963indr_is
inerts64517023iner_ts
inflows1335523inflows
informs1248073informs
infos84311673in_fo_s
ingots7912063in_gots
ingroup1044333ingroup
ingroups1143483ingroups
ingrown1145393ingrown
inions64417003in_ions
inkless11348713inkless
inkpots1335173inkpots
inmost8411363in_most
innless7288293innless
inro45920793in_ro__
inroad737933in_road
inroads837043in_roads
inruns6359513in_runs
inrush936513in_rush
inscroll10113213inscroll
inscrolls11112483inscrolls
intercross1246213intercross
intorts7310973intorts
intro54915853intro__
introfy1344753introfy
introit7414533introit
introits859713introits
intron64215023intro_n
introrse846043introrse
intrust7311493intrust
intrusts837723intrusts
inures63318953inur_es
inurns63310983inur_ns
inwraps12105253inwraps
irons55324133i__rons
kaross101910013_kaross
lacrosse1044113lacrosse
linurons846333linurons
macrons113514893macrons
macros104017013macro_s
microns113814783microns
micros104115363micro_s
necrose939723necrose
necroses10310563necroses
necrosis1048883necrosis
nerols6914883_nerols
nicols8810243nic_ols
nimrods1044283nimrods
nitros64214123nitro_s
nitroso7326453nitroso
nitrous73512483nitrous
onerous7312973onerous
outcross1036823outcross
pingrass1146003pingrass
pross76529403__pross
ringtoss944203ringtoss
scrods94111603_scrods
sucrose939303sucrose
sucroses1039933sucroses
topcross1253383topcross
unclogs1036803unclogs
unclose91111643unclose
uncloses10910943uncloses
uncorks1337443uncorks
uncos74117033unc_o_s
uncrossed1236313uncrossed
uncrosses1146153uncrosses
uncrown1236323uncrown
uncrowns1344363uncrowns
undress838893undress
untruss736553untruss
windrows1546163windrows
zincous1837053zinc_ous

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.1561145455.1
2DLD Change Limit1340271647.36018210.2
3Display Results1641640.0463565.2
 (SQL Overall)1786911647.56223630.1
 
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.