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 “chinas” with Change Limit: [1] [2] [3]

You can choose a higher Change Limit to return more words, although it will take longer.
to automatically increase the Change Limit after seconds.

92 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
chinas11511940(None) 
chias104625521chi_as
chicas135916471chicas
china105022481china_
chines115029171chines
chinks155817571chinks
chinos115018691chinos
chins105631461chin_s
chints115117831chints
cains75334302cain_s
cannas84518402cannas
carinas93622402carinas
ceibas1038502ceibas
chaines124518732chaines
chains114819702chain_s
changs125215372changs
chants115020392chants
charas114223612charas
chelas113817202chelas
chia96026622chi_a_
chiao105618362chi_ao
chiasm13449102chi_asm
chiaus113611312chiaus
chica125818262chica_
chicks175317592chicks
chicos134614832chicos
chics123920942chi_cs
chides124620472chides
chiefs14509652chiefs
chiels115115932chiels
chiles115425302chiles
chilis115517872chilis
chills114717702chills
chimar133911472chimar
chimars144010592chimars
chimbs153910302chimbs
chimes134922572chimes
chimlas1437452chimlas
chimps155713662chimps
chin96934742chin__
chinch163911232chinch
chine105231722chin_e
chined125620062chined
chink145321592chin_k
chinky185610542chinky
chino105823312chin_o
chintz204212032chintz
chinwag1643552chinwag
chinwags1743382chinwags
chips125721252chi_ps
chiral114614412chiral
chirks155414842chirks
chirms135113982chirms
chiros114617772chiros
chirps135414002chirps
chirrs114514982chirrs
chirus114615692chirus
chis95933312chi__s
chital114313882chital
chits105424572chi_ts
chives144317592chives
cholas114818002cholas
chufas14397672chufas
chunks154210332chunks
cines75239682c_ines
clinal8311552clinal
clines84926042clines
clings95716212clings
clinks125815062clinks
coins75834552coin_s
echidnas1443382echidnas
echinus1236202echinus
hinds96721472_hinds
hins76447992_hin_s
hints87330622_hints
kachinas1736342kachinas
kinas95626912_kinas
minas75434112_minas
ohias84415572ohi_as
pinas75434452_pinas
rhinal9510192rhinal
rhinos94411122rhinos
shines95028912shines
shins85131042shin_s
shivas124512412shivas
things104914302things
thinks134613362thinks
thins85826332thin_s
vinas85126342_vinas
whenas124610462whenas
whines125120102whines
whins114922332whin_s

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 Filter178691825510.686260482.5
2DLD Change Limit82551925.25015724.0
3Display Results92920.0631460.3
 (SQL Overall)178691925.99929786.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.