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

96 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
cheap12691594(None) 
chap114928491ch_ap
cheapo134810081cheapo
cheaps134613681cheaps
cheat105732451cheat
cheep125416501cheep
heap96432891_heap
ahead96817052ahead
cap76758982c__ap
cep75736332c_e_p
chad105525502ch_ad
chai95929902ch_ai
cham115532312ch_am
champ145017962champ
chao95727312ch_ao
chape125221142ch_ape
chaps125326062ch_aps
chapt125827642ch_apt
char95132152ch_ar
chat95546132ch_at
chaw126224632ch_aw
chay124924872ch_ay
cheapen14407622cheapen
cheaper144010582cheaper
cheapie1437562cheapie
cheaply1735022cheaply
cheapos14418512cheapos
cheats114519542cheats
check164714712check
cheek145115712cheek
cheeps135312912cheeps
cheer105420382cheer
chef125125622che_f
chefs136214662chefs
chela103916802chela
chelae113614612chelae
chelas113817202chelas
chemo12313632chemo
chert105232102chert
chess105016922chess
chest104926142chest
chetah14399582chetah
cheth135013822cheth
chevy16479992chevy
chew126622132che_w
chews135418512chews
chewy165011902chewy
chez184519022che_z
chia96026622chia_
chiao105618362chiao
chias104625522chias
chimp145216472chimp
chip116726422ch_ip
chirp124717162chirp
chomp144815662chomp
chop116024922ch_op
chump145315442chump
clap86429042c_lap
clean75420412clean
clear76219052clear
cleat76335062cleat
cohead123811122cohead
crap85731842c_rap
creak115418432creak
cream95721352cream
creep95218102creep
hap87360052_h_ap
head87137172_head
heal75645692_heal
heaps105223222_heaps
heapy135914982_heapy
hear76143882_hear
heat77061422_heat
help95328922_help
hemp115725622_hemp
hep86644142_he_p
leap66032682_leap
neap66927012_neap
reap65934742_reap
rhea75017432rhea_
rheas84816952rheas
shea76031572shea_
sheaf115424122sheaf
sheal84927702sheal
shear85424832shear
sheas86331792sheas
sheep105321522sheep
sneap75514822sneap
thesp105410312thesp
threap11569662threap
upheap13105212upheap
whap125119642wh_ap
wheal115716182wheal
wheat114924572wheat
wheep136214352wheep
whelp136012092whelp

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 Filter178691538000.313570897.8
2DLD Change Limit53800962.23324093.1
3Display Results96960.0631523.8
 (SQL Overall)178691962.60968490.2
 
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.