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

97 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
chimps15571366(None) 
champs154915681champs
chimbs153910301chimbs
chimes134922571chimes
chimp145216471chimp_
chips125721251chi_ps
chirps135414001chirps
chomps155112221chomps
chumps154313821chumps
crimps124613451crimps
blimps12588152blimps
camps116330262c_amps
champ145017962champ_
champy18509612champy
chams126028502cham_s
chaps125326062ch_aps
cheaps134613682cheaps
cheeps135312912cheeps
chemos13311722chemos
chias104625522chi_as
chiaus113611312chiaus
chicas135916472chicas
chicks175317592chicks
chicos134614832chicos
chics123920942chi_cs
chides124620472chides
chiefs14509652chiefs
chiels115115932chiels
chiles115425302chiles
chilis115517872chilis
chills114717702chills
chimar133911472chimar
chimars144010592chimars
chimb144813562chim_b
chime125322592chim_e
chimed145814832chimed
chimer135517202chimer
chimers144515142chimers
chimla1337592chimla
chimlas1437452chimlas
chinas115119402chinas
chines115029172chines
chinks155817572chinks
chinos115018692chinos
chins105631462chi_ns
chints115117832chints
chip116726422chi_p_
chippy18437612chippy
chirks155414842chirks
chirms135113982chirms
chiros114617772chiros
chirp124717162chirp_
chirpy16498912chirpy
chirrs114514982chirrs
chirus114615692chirus
chis95933312chi__s
chits105424572chi_ts
chives144317592chives
chomp144815662chomp_
chops125019872ch_ops
chump145315442chump_
chums125015832chum_s
chymes165912152chymes
clamps124515082clamps
climbs12498722climbs
climes104720002climes
clips96018302cli_ps
clomps125212232clomps
clumps1215314642clumps
comps115526052c_omps
cramps125615562cramps
crimes105521582crimes
crimp115615802crimp_
crimpy15489392crimpy
crisps104411512crisps
crumps124514342crumps
gimps105915202_gimps
hemps126917332_hemps
hims95230982_him_s
hips96433712_hi_ps
humps126322802_humps
imps86221122__imps
limps95522672_limps
pimps114616982_pimps
primps124711822primps
scrimps13517902scrimps
shims104422552shim_s
ships105123772shi_ps
shrimps14516752shrimps
simps94719762_simps
skimps14488042skimps
thumps13449352thumps
whims134515332whim_s
whips134917082whi_ps
whomps16457602whomps
whumps16427092whumps
wimps125213802_wimps

Search took 3 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.346516448.0
2DLD Change Limit82551972.17038041.9
3Display Results97970.0166062.5
 (SQL Overall)178691972.53270573.1
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.