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

144 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
orchids137721(None) 
orchid1289571orchid_
orchils1277701orchils
orchis11710771orchi_s
archils12510532archils
orceins937742orceins
orchards1445912orchards
orchil1158652orchi_l
orchises1338772orchises
orchitis1346422orchitis
orcins83313432orc_ins
urchins1238862urchins
acids87121003_ac_ids
alcids94812293alc_ids
aphids125110843_aphids
arachnids1574303arachnids
aramids102810503aramids
arched125717323arched_
archers124414573archers
arches114822043arch_es
archil11611573archi_l
archine125817053archine
archines133815253archines
arching136216693arching
archings14499863archings
archive154610483archive
archives16399553archives
archons12311583archons
arctics1138953arctics
aroids75118223ar_oids
arshins10312573arshins
boychiks2242933boychiks
braids95015683br_aids
bromids12278603bromids
caids85226423__caids
chads116122233__chads
chias104625513__chias
chics123920943__chics
chid106626403__chid_
chide115321013__chide
chides124620473__chides
chins105631463__chins
chips125721253__chips
chis95933313__chi_s
chits105424573__chits
cichlids1643663cichlids
coccids11277213coccids
coccoids12176793coccoids
cochins141413093cochins
conchies153214853conchies
conchoids1766263conchoids
coracoids1445833coracoids
corvids1337673cor_vids
cricoids1347183cricoids
droids84712583dr_oids
druids8368093dr_uids
duchies133312313duchies
forbids13268263for_bids
fucoids1335663fucoids
glochids1543953glochids
grids75321393gr__ids
hoochies1639593hoochies
irids66417763ir__ids
lichis115212593lichi_s
monorchids1844973monorchids
morphias1546833morphias
morphins1538643morphins
mucoids1237413mucoids
ochers113915303o_chers
ochres113510833o_chres
octads987333o_ctads
ohias84415563o__hias
ootids71110353o_otids
opioids1036523opioids
oraches124216473orach_es
orbits84211433or_bits
orcas75918623orc__as
orcein838183orcei_n
orchard1346933orchard
orchitic1546283orchitic
orcin72716573orc_i_n
orcs67025433orc___s
ordains879653ordains
oreads73915773or_eads
oreide7311673or_eide
oreides8312023or_eides
orgies72316093or_gies
oribis838833oribi_s
origins8310463origins
ornis54616773or_ni_s
oroide7311703or_oide
oroides8311973or_oides
orphans1237773orphans
orphic1368323orphi_c
orphism1446183orphism
orphisms1545993orphisms
orpins83614163or_pins
orris54516553or_ri_s
ouched124316933ouched_
ouches114322183ouch_es
ouching134314903ouching
outbids1098913outbids
outchid1338723outchid_
outchide1447213outchide
outchides1546783outchides
outhits102213503outhits
ovoids10456923o_voids
oxids13128963o__xids
ozalids1794063ozalids
percoids1339663percoids
porches143815673porch_es
prebids12399873prebids
rachides141511223rachides
rachis114017653rachi_s
raids65827513_r_aids
ranids75118703_ranids
rapids94913893_rapids
rebids94015523_rebids
resids74219153_resids
rids56539543_r__ids
rochets124213473rochets
roshis9311793roshi_s
sarcoids1137803sarcoids
syrphids1744243syrphids
techies12513603techies
torched133511353torched_
torches123715433torch_es
torchier1337463torchier
torchiers1445073torchiers
torchiest1438033torchiest
torching142510083torching
torchons1337503torchons
toroids8310643tor_oids
torpids1037373tor_pids
tracheids1545053tracheids
trochils1388583trochils
trochoids1546593trochoids
urchin1138743urchi_n
ursids737823ur_sids
vichies15310623vichies
whids125413983__whids
worships1647093worships
worthies14310283worthies
zechins21137123zechins

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.1431249587.4
2DLD Change Limit1340271446.79619721.5
3Display Results1441440.0602400.0
 (SQL Overall)1786911446.99925530.9
 
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.