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

62 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
chicanos159599(None) 
chicanes1559371chicanes
chicano1496871chicano_
chicane1489552chican_e
chicaned1665872chicaned
chicaner1586072chicaner
chicaners1685362chicaners
chicas135916472chica__s
chicos134614832chic__os
chinos115018692chi__nos
cacaos104616183c_aca_os
caimans113811783caiman_s
cancans11311873cancan_s
changs125215373ch__angs
chants115020393ch__ants
chaos105622863ch__a_os
chazans21268123chazan_s
cheapos14418513ch_eapos
chechakos23112183chechakos
chianti1236613chi_anti
chiantis1346593chi_antis
chiao105618363chi_a_o_
chias104625523chi_a__s
chiasms14357523chi_asms
chiaus113611313chi_a_us
chica125818263chica___
chicalote16123813chicalote
chicalotes17163563chicalotes
chicanery19103053chicanery
chicaning1745163chicaning
chichis1737073chic_his
chickees19258513chickees
chickens19267433chickens
chicks175317593chic__ks
chicles143512503chic_les
chicness1535593chicness
chico124218253chic__o_
chics123920943chic___s
chiffons1943693chiffons
chignon1344623chi_gnon
chignons1444713chi_gnons
chimars144010593chima_rs
chinas115119403chi__nas
chines115029173chi__nes
chinks155817573chi__nks
chino105823313chi__no_
chinones13510473chinones
chins105631463chi__n_s
chints115117833chi__nts
chiros114617773chi__ros
chitinous1474993chitinous
chitins122713793chitin_s
chitons122611913chiton_s
cicadas1235993c_icadas
cicalas1139303c_icalas
ciceros1158583c_iceros
gitanos837173_gitanos
paisanos10337553paisanos
pianos84315933_pi_anos
picaros11310893_picaros
rhinos94411123rhi__nos
volcanos1344733volcanos

Search took 7 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.423422437.4
2DLD Change Limit146162626.50022486.5
3Display Results62620.0134769.2
 (SQL Overall)178691626.93625762.8
 
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.