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

193 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
chequer213515(None) 
cheque2036661cheque_
chequers2234101chequers
cheques2136861cheques
cheaper144010582cheaper
cheater124816952cheater
checker18329532checker
cheder125113492che_der
cheeper143610742cheeper
cheer105420382che__er
cheerer123511752cheerer
chequered2442612chequered
chewer145512612che_wer
chewier1537582chewier
claquer18287342claquer
conquer1838612conquer
exchequer3051342exchequer
caique17318803caique_
caiques18248793caiques
calque17289843calque_
calqued19306523calqued
calques182710193calques
casque17299273casque_
casqued19235633casqued
casques18278983casques
ceder85322233c_e_der
ceiler84013963c_eiler
censer84516583c_enser
center84421413c_enter
chafer144714573ch_afer
chaffer18389473chaffer
chamber164011053chamber
chamfer17399853chamfer
champer163813403champer
chancer144215633chancer
changer134215543changer
chanter123919733chanter
chapter144213853chapter
chaqueta2242753chaqueta
charger133914063charger
charier124317903charier
charmer144913663charmer
charter123918303charter
chaser114918383ch_aser
chaster124718503chaster
chatter124416643chatter
chaufer15347943chaufer
chawer144314413ch_awer
cheapen14407623cheapen
cheated134416343cheated
cheaters133613503cheaters
chebec1536963che_bec
checked193710023checked
checkers19317843checkers
cheddar14254733cheddar
cheders134512393che_ders
cheek145115713che__ek
cheeked17399663cheeked
cheekier1735103cheekier
cheep125416503che__ep
cheeped153410593cheeped
cheepers15329013cheepers
cheered133713293cheered
cheerers13319543cheerers
cheerier1348003cheerier
cheero114712933che__ero
cheers114518913che__ers
cheery144913153che__ery
cheese113812763cheese_
cheesed133910683cheesed
cheeses123613103cheeses
cheesier1335963cheesier
chefed155010563che_fed
cheffed19335863cheffed
chegoe1237273chegoe_
chegoes1337333chegoes
chelae113614603chelae_
chequering2543123chequering
chertier1387873chertier
cherub1337263cheru_b
cherubs1434553cherubs
chesses124112633chesses
chested133811673chested
chestier1387423chestier
chevied16357483chevied
chevies153511443chevies
chevre14318313chevre_
chevres15379793chevres
chevret153310633chevret
chewed154415013che_wed
chewers154111133che_wers
chicer134513603ch_icer
chider125116053ch_ider
chiefer1536863chiefer
chigger1436003chigger
chiller124112183chiller
chimer135517203ch_imer
chipper163912583chipper
chirker16429323chirker
chirper14359963chirper
chitter124112963chitter
choicer14197893choicer
choker154314373ch_oker
chokier1638043chokier
choler113717153ch_oler
chomper163810073chomper
chooser124412963chooser
chopper163611893chopper
chouser125212943chouser
chowder16387803chowder
chudder14245943chudder
chuffer18337143chuffer
chugger1445373chugger
chukker1543833chukker
chunter123911473chunter
churner12298343churner
churr104512853ch__urr
cinque1736853cinque_
cinques1837333cinques
cirque1735853cirque_
cirques1836463cirques
claque17338563claque_
claquers19226193claquers
claques18279013claques
claqueur19262703claqueur
cleaner93712303cleaner
clearer93710823clearer
cleaver124110803cleaver
clever114611533cle_ver
clique17289193clique_
cliqued19266683cliqued
cliques18309203cliques
cliquey21295693cliquey
cliquier1944223cliquier
cloque17288743cloque_
cloques18268563cloques
coenure968143coenure
coequal1844933coequal
coercer1138383coercer
coherer122912783cohe_rer
conquers1938213conquers
coquet174318013c_oquet
creamer113714083creamer
creaser94415723creaser
creeper11339973creeper
crepier1139733crepier
croquet1859683croquet
exchequers3151073exchequers
header104422543_header
healer94221803_healer
heaper114119523_heaper
hearer94323643_hearer
heater94828303_heater
heaver124819673_heaver
heder95623633_he_der
hedger114912633_hedger
heeder104216043_heeder
heeler93917313_heeler
hefter124313923_hefter
heifer1238203_heifer
heller93322513_heller
helper114313093_helper
hemmer134112643_hemmer
hepper133412663_hepper
herder104516463_herder
hewer115719933_he_wer
hexer155116683_he_xer
lacquer18135153lacquer
masquer18266463masquer
opaquer1842403opaquer
prequel1836343prequel
queuer15357253que_uer
scheduler1562193scheduler
schemer1477953sche_mer
sequel1556713_sequel
shearer104414683shearer
shedder12339323shedder
sheer84726893she__er
sheerer103813843sheerer
sheeter103814903sheeter
sheller103515883sheller
shelter103214953shelter
shelver134211063shelver
sheqel1846523sheq_el
shewer124515103she_wer
theater104014253theater
thewier1336063thewier
torquer16205323torquer
uniquer1675783uniquer
wheeler13298773wheeler
wheezer22296673wheezer
whether16346623whether
whetter13348803whetter

Search took 8 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.1531167915.0
2DLD Change Limit1340271936.94019312.2
3Display Results1931930.0603216.7
 (SQL Overall)1786911937.15324981.3
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.