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

71 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
chorizos224549(None) 
chorizo2136321chorizo_
chorines132917252chorines
chorion12311772chori_on
chorions13310662chorions
horizon1955762_horizon
horizons2045462_horizons
aphorizes2348013aphorizes
calorizes202312303calorizes
chamisos15307423chamisos
chariot12316213chari_ot
chariots1339393chariots
charisms15710263charisms
charros124312143char_ros
cheerios13317583cheeri_os
chicos134614833ch__icos
chinos115018693ch__inos
chiros114617773ch__iros
chlorides15289753chlorides
chlorids14299673chlori_ds
chlorines142512353chlorines
chlorins132612883chlori_ns
chlorites142311963chlorites
choices142010613cho_ices
choirboy1842233choirboy
choirboys1941903choirboys
choirs114911883cho_i_rs
cholines132214493cholines
cholos114716853cho__los
chopines152711733chopines
chopins142312243chopi_ns
choragus1474303choragus
chorales133712883chorales
chorals124614113chor_als
chords125214633chor__ds
choreas124414203chor_eas
choregus1484213choregus
chores114828023chor__es
chorial124214143chori_al
choriamb1744163choriamb
choriambs1842453choriambs
choric133515903chori__c
chorine123218363chori_ne
choring133617663chori_ng
chorioid1448333chorioid
chorioids1545683chorioids
choroids1438693choroids
chortens13308793chortens
chortles133611323chortles
chorus115014773chor__us
choruses1339983choruses
chrisms1499143ch_risms
chrisom1466623ch_risom
chrisoms1566093ch_risoms
chromizes2547603chromizes
chromos142610273ch_romos
churros12427583chur_ros
cogitos1037613c_ogitos
colorizes203014523colorizes
coryzas2134803c_oryzas
curios83218333c_uri_os
hornitos1145393_hornitos
odorizes1837213odorizes
orzos143311253__or_zos
scherzos2243703scher_zos
schizos21115433sch__izos
shorings12269483shorings
theorizes2147073theorizes
thorias102312053thori_as
thorites11312393thorites
thoriums13166403thoriums

Search took 9 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 Filter1786911461620.420425454.8
2DLD Change Limit146162717.75318852.3
3Display Results71710.0461543.5
 (SQL Overall)178691718.21921741.2
 
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.