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

210 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
chirpier1527630(None) 
chippier17297671chippier
chirper14359961chirp_er
charier124317902char_ier
charrier1378682charrier
chertier1387872chertier
chichier1836022chichier
chillier13328422chillier
chinkier17377362chinkier
chipper163912582chi_pper
chippie16297692chippie_
chippies17309762chippies
chirker16429322chir_ker
chiropter1644832chiropter
chirped15379782chirp_ed
chirpers15358132chirp_ers
chirpiest16286482chirpiest
chirpily1843772chirpily
chirping16278862chirping
choppier17286642choppier
crimpier14287322crimpier
crispier12297252crispier
hippier143212102_hippier
shirtier1137942shirtier
whippier18265822whippier
whirlier14175292whirlier
airier64619363_air_ier
campier133313273c_ampier
carper104923633c_arp_er
carrier93619583c_arrier
chaffier1935473chaffier
chalkier1736753chalkier
champer163813413champ_er
chancier1538823chancier
chapiter1536603ch_apiter
chappie16298663chappie_
chappies172610103chappies
chapter144213853ch_apter
charger133914063char_ger
charlie123011923charlie_
charlies133414233charlies
charmer144913663char_mer
charter123918303char_ter
chattier1337513chattier
cheaper144010583cheap_er
cheapie1437563cheapie_
cheapies1539033cheapies
cheekier1735103cheekier
cheeper143610743cheep_er
cheerier1348003cheerier
cheesier1335963cheesier
cherries131812983cherries
chestier1387423chestier
chewier1537593ch_ewier
chicaner1586073chicaner
chicer134513603chi__cer
chider125116053chi__der
chiefer1536863chi_efer
chigger1436003chi_gger
childlier1543093childlier
chilies124218303chi_lies
chiller124112183chi_ller
chillies134113483chillies
chimer135517203chi__mer
chinchier1944633chinchier
chintzier2342663chintzier
chipped174110813chi_pped
chippers173510883chi_ppers
chippiest18256813chippiest
chipping18389793chipping
chirked173810333chir_ked
chirking18339383chirking
chirmed15379733chir_med
chirming16318643chirming
chiropters1744753chiropters
chirp124717163chirp___
chirps135414003chirp__s
chirpy16498913chirp__y
chirr105015903chir___r
chirre114111853chir_re_
chirred133612123chir_red
chirren12388743chir_ren
chirres123812253chir_res
chirring142610173chirring
chiseler1335903chiseler
chitter124112963chi_tter
chitties13310773chitties
chivied16368383chi_vied
chivies153412853chi_vies
chivvied2052523chivvied
chivvies1954423chivvies
chokier1638043ch_okier
chomper163810073chomp_er
choosier1337173choosier
chopper163611893ch_opper
chortler13336843chortler
chromier1538033chromier
chubbier1733893chubbier
chuffier1934543chuffier
chummier1734513chummier
chunkier17395883chunkier
churchier1944153churchier
churner12298343chur_ner
cipher133710263c_i_pher
circler1136423c_ircler
cliffier1633913cliffier
clingier1155853clingier
clipper133710323cli_pper
cliquier1944223cliquier
clumpier1435583clumpier
copier103722893c__opier
corkier133114303c_orkier
cornier93017093c_ornier
courier93617893cour_ier
courtier1059333courtier
crampier14288903crampier
crappier14288133crappier
creepier1236253creepier
crepier1139743c_repier
crier74724463c__r_ier
crimper136510423crimp_er
crippler14826713crippler
crisper113511053crisp_er
croupier1246883croupier
cuppier1368323c_uppier
curdier103312623c_urdier
curlier93314183c_urlier
currier93316703c_urrier
curvier123110663c_urvier
dippier123111393_dippier
dirtier83312093_dirtier
drippier1385043drippier
firrier103410133_firrier
flirtier1144893flirtier
gimpier12247943_gimpier
girlier8289523_girlier
gripier103210323gri_pier
grippier1355203grippier
hairier103111053hair_ier
happier143312043_happier
hardier114721543_hardier
harper115018403_harp_er
harpies123818323_harpies
harrier104417753_harrier
hempier14319003_hempier
herbier1239593_herbier
hillier103413963_hillier
hinkier143610793_hinkier
hipper133818023_hi_pper
hippie132811243_hippie_
hippies142813753_hippies
hirer85423123_hir__er
hirple11158973_hirple_
hirpled13157143_hirpled
hirples12149643_hirples
hissier103410503_hissier
hoppier143110703_hoppier
hornier103012463_hornier
horsier103013243_horsier
humpier143110723_humpier
hurrier103412943_hurrier
lippier112710573_lippier
mirier83918363_mir_ier
mirkier13319053_mirkier
nippier11319833_nippier
pipier104913983_pi_pier
quippier2133773quippier
quirkier2134163quirkier
schizier2234063schi_zier
schizzier2242253schizzier
scrimpier1554243scrimpier
sharper124312703sharp_er
sharpie1238403sharpie_
sharpies13411233sharpies
shiftier1436343shiftier
shinier104113143shi_nier
shipper143514043shi_pper
shirker143711343shir_ker
shittier1137313shittier
shrimpier1643063shrimpier
sirupier1034303_sirupier
skimpier1634293skimpier
slippier1256543slippier
smirkier1444433smirkier
snippier1255793snippier
spirier93214073spir_ier
stripier1058863stripier
swirlier1135213swirlier
thirster1135673thirster
thirstier1243693thirstier
thirties1139723thirties
thornier1135323thornier
tippier113210543_tippier
trippier1246623trippier
twirlier1133513twirlier
whimper17297723whimp_er
whinier134110633whi_nier
whinnier14255003whinnier
whipper173611383whi_pper
whirler13307603whir_ler
whirlies14167373whirlies
whirried15154103whirried
whirries14136693whirries
whisper15298013whisp_er
whitier133311063whi_tier
whizzier2233283whizzier
wimpier14248053_wimpier
wirier94215553_wir_ier
wispier12249403_wispier
zippier20308193_zippier

Search took 9 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.703254183.5
2DLD Change Limit1461622107.53019410.6
3Display Results2102100.0802625.0
 (SQL Overall)1786912108.31321495.4
 
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.