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

139 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
chinchy2033551(None) 
chinch163911231chinch_
chancy164010862chanc_y
chichi1637092chi_chi
chicly16429202chi_cly
chinches18369362chinches
chinky185610542chin_ky
chintzy24364222chintzy
churchy2044182churchy
cinch124516242c_inch_
clinch133910352clinch_
conchy163710222c_onchy
crunchy17324762crunchy
achingly1736613achingly
bitchy16479203_bitchy
branchy17357913branchy
bunchy16437463_bunchy
cancha134411613c_ancha
catchy16559583c_atchy
chance134617093chanc_e
chanced154113213chanced
chancel144011773chancel
chancer144215633chancer
chancery18366653chancery
chances145218093chances
chancily1845243chancily
chancre14348783chancre
chantey154112543chantey
chantry15388223chantry
chanty145215823chan_ty
chic115925203chi_c__
chica125818263chi_c_a
chicas135916473chi_cas
chiccory1742483chiccory
chicer134513603chi_cer
chichis1737073chi_chis
chick165419133chi_c_k
chicks175317593chi_cks
chicle134312543chi_cle
chico124218253chi_c_o
chicory1735993chicory
chicos134614833chi_cos
chics123920943chi_c_s
chiefly1834103chiefly
childly1644803childly
chilly144113223chi_lly
chimbly1974593chimbly
chimley1785163chimley
chimney1795483chimney
chin96934743chin___
china105022483chin__a
chinas115119403chin_as
chinchier1944633chinchier
chine105231723chin__e
chined125620063chin_ed
chines115029173chin_es
chining133316843chining
chink145321593chin__k
chinked174011023chinked
chinks155817573chin_ks
chinned134810493chinned
chino105823313chin__o
chinone12510153chinone
chinook1675103chinook
chinos115018693chin_os
chins105631463chin__s
chints115117833chin_ts
chintz204212033chin_tz
chinwag1643553chinwag
chippy18437613chi_ppy
chirpy16498913chi_rpy
chitchat1846053chitchat
chitty14329433chi_tty
chivvy20374433chi_vvy
chivy164810363chi__vy
chucky20418003ch_ucky
chunky18468273chun_ky
church1636483church_
churchly2142973churchly
cinched153910863c_inched
cinches144215773c_inches
clench133910053clench_
cliche133712453cli_che
clinched16347383clinched
clincher15347663clincher
clinches153910363clinches
clingy12659063clin_gy
clutchy17323893clutchy
conch124620073c_onch_
concha134213283c_oncha
concho134414263c_oncho
conchs134714903c_onchs
cranch133613533cranch_
crinkly16387523crinkly
crunch13349503crunch_
dinghy14476963_dinghy
finch135416973_finch_
fitchy17437623_fitchy
flinch144010103flinch_
glitchy16283083glitchy
grinch1238473grinch_
hinky155618753_hin_ky
hinny115616673_hin_ny
hitch134515473_hitch_
honcho14389383_honcho
hunch136416213_hunch_
inch95420823__inch_
itchy13449013__itchy
mincy125817413_minc_y
painch133511323painch_
paunchy17324443paunchy
pinch125619303_pinch_
pitchy16479673_pitchy
punchy16398523_punchy
raunchy15284313raunchy
rhonchi1542493rhonchi
scrunchy1852383scrunchy
shindy13449323shin_dy
shingly143210813shingly
shinily13268933shinily
shinney13368293shinney
shinny124810783shin_ny
shiny115122143shin__y
spinachy1842793spinachy
stenchy15256213stenchy
thatchy1833303thatchy
thinly1238673thin_ly
twitchy18393573twitchy
vichy1639043_vi_chy
which163910083whi_ch_
whinchat1944343whinchat
whiney155012643whin_ey
whinny15587493whin_ny
whiny144915573whin__y
wincey144110383_wincey
winch135016663_winch_
witchy17468593_witchy
zincky24404963_zincky
zincy195413513_zinc_y

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 Filter1786911340270.1401276364.3
2DLD Change Limit1340271396.04622167.9
3Display Results1391390.0463021.7
 (SQL Overall)1786911396.23228673.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.