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

196 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
chapiter153660(None) 
chapiters1635191chapiters
chapter144213851chap_ter
chanter123919732cha_nter
chapters154012112chap_ters
charier124317902chari_er
charter123918302cha_rter
chaster124718502cha_ster
chatter124416642cha_tter
chattier1337512chattier
chaunter1366382chaunter
cohabiter1643962cohabiter
accipiter15133743accipiter
adapter1036173adap_ter
apter76120203__ap_ter
awaiter1057443awa_iter
baiter84422553_ba_iter
cagier93715933c_agi_er
cahier113615773c_ahi_er
cakier123115243c_aki_er
caliber1139733c_aliber
caliper11410963c_aliper
campier133313273campi_er
canister101710853c_anister
canter85230113c_a_nter
caper94831623c_ap__er
caperer113013403c_aperer
capita102913773c_apit_a
capital112311523c_apital
capitol11258283c_apitol
capizes20410373c_apizes
capote10315733c_apote_
capotes11314643c_apotes
capper124421983c_ap_per
captor104914603c_ap_tor
carter84932273c_a_rter
caster85232573c_a_ster
cater74840703c_a__ter
cattier93317073c_attier
caviler1249063c_aviler
chafer144714573cha__fer
chaffer18389473cha_ffer
chaffier1935473chaffier
chaine115119223cha_ine_
chained133812693cha_ined
chaines124518733cha_ines
chair105519633cha_i__r
chaired134211243cha_ired
chaise114916413cha_ise_
chaises124317493cha_ises
chalice14311043chalice_
chaliced1637043chaliced
chalices15310813chalices
chalkier1736753chalkier
chamber164011053cha_mber
chamfer17399853cha_mfer
chamise143612853chamise_
chamises153513313chamises
champer163813403cha_mper
chancer144215633cha_ncer
chancier1538823chancier
chandler14358373chandler
changer134215543cha_nger
chanted134015953cha_nted
chanters134016723cha_nters
chantey154112543cha_ntey
chanties132615803chanties
chantor123710313cha_ntor
chapati14118003chapat_i
chapatis15127923chapatis
chapatti15113863chapatti
chape125221143chap__e_
chapel134911373chap__el
chapes135421873chap__es
chaplet14512253chap_let
chapleted1743963chapleted
chaplets1556883chaplets
chapmen1637283chap_men
chapped172711443chap_ped
chappie16298653chappie_
chappies172610093chappies
chapt125827643chap_t__
chapteral1644683chap_teral
chaptered17176783chap_tered
character1645883character
charger133914063cha_rger
charioted1595863charioted
charioteer1552753charioteer
charities14312733charities
charity15311023charit_y
charmer144913663cha_rmer
charrier1378683charrier
charted135116853cha_rted
charters134115563cha_rters
chaser114918383cha__ser
chaste114617393cha_ste_
chasten124312403cha_sten
chastiser1444373chastiser
chatted133411893cha_tted
chattel12388893cha_ttel
chatters134213933cha_tters
chattery16357273cha_ttery
chaufer15347943cha_ufer
chauffer19263793chauffer
chaunted1485603chaunted
chaunters1455813chaunters
chawer144314413cha__wer
chayote1536493chayote_
chayotes1636493chayotes
cheapener1643773cheapener
cheaper144010583cheap__er
cheapie1437563cheapi_e_
cheapies1539033cheapi_es
cheater124816953ch_eater
chedite1338863chedite_
chedites1438263chedites
chertier1387873chertier
chestier1387423chestier
chewier1537583chewi_er
chicer134513603ch__icer
chider125116053ch__ider
chimer135517203ch__imer
chipper163912583chip_per
chippier17297673chippier
chirpier15276303chirpi_er
chitter124112963ch_itter
choicer14197893ch_oicer
chokier1638043choki_er
chopine143512263chopine_
chopines152711733chopines
chopper163611893chop_per
choppier17286643choppier
chorister1487143chorister
chunter123911473ch_unter
citer74827323c___iter
claimer11279883cla_imer
clapper134011863clap_per
clatter94014973cla_tter
clavier1239173clavi_er
clayier1248323clayi_er
coalier93416173coali_er
coapted123911493coap_ted
coaster94219033coa_ster
coater84329553coa__ter
cohabited1744023cohabited
cohabiters1743403cohabiters
compiler1438373compiler
computer144511503computer
copier103722893c_opi_er
copter109822013c_op_ter
cowriter13238883cowriter
crafter124111333cra_fter
craftier1376193craftier
crampier14288903crampi_er
crapper133913193crap_per
crappier14288133crappier
crater85026633cra__ter
crazier183610743crazi_er
crepier1139733crepi_er
cuppier1368323cuppi_er
cyanite122710763cyanite_
cyanites132610153cyanites
gaiter73819503_ga_iter
grapier103712603grapi_er
habited1337883_habited
hafter124815883_ha_fter
hailer94720343_ha_iler
halite93624233_halite_
halites103221193_halites
halter94420883_ha_lter
hamster12810423_hamster
haplite12310703_haplite_
haplites1339993_haplites
happier143312033_happier
hapten115312983_hap_ten
hastier103916623_hastier
hater85034753_ha__ter
hatter94724873_ha_tter
haunter103111153_haunter
hazier184712403_hazi_er
hipster12288783_hipster
inhabiter1444483inhabiter
phatter123810203pha_tter
plaiter93615393pla_iter
rapider1067903_rapider
rapier84019993_rapi_er
shadier113111153shadi_er
shakier143411153shaki_er
shalier103116423shali_er
shaper114119933shap__er
shatter103615693sha_tter
soapier93411713soapi_er
tapster9299273_tapster
waiter94321253_wa_iter
whapper17348273whap_per
whiter124316393wh__iter

Search took 10 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 Filter1786911461620.1561145455.1
2DLD Change Limit1461621969.08016097.1
3Display Results1961960.0762578.9
 (SQL Overall)1786911969.31219189.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.