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

277 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
phreak153615(None) 
phreaks1634541phreaks
break115319402_break
creak115418432_creak
freak125115242_freak
peak106535202p__eak
perea75026442perea_
phreaked1834492phreaked
phreaker1735052phreaker
screak125311052screak
streak104613622streak
thread105011092thread
threap11569662threap
threat95020462threat
wreak125513272_wreak
ahead96817053ah_ead
apeak115513453_apeak
arak86929573_ar_ak
area45843393_area_
areae55229743_areae
areal55928733_areal
areas55935773_areas
arrear6310253arrear
beak106534383__beak
bleak115915383_bleak
boreal84817213boreal
boreas85421733boreas
bread85523113_bread
breaks124816423_breaks
bream95121813_bream
bureau8712523bureau
cereal8315833cereal
cheap126915943ch_eap
cheat105732453ch_eat
check164714713ch_eck
cheek145115713ch_eek
chorea115216083chorea_
choreal124412223choreal
choreas124414203choreas
creaks124315963_creaks
creaky154911553_creaky
cream95721343_cream
creek114917393_creek
croak115216633_croak
debeak1336763debeak
dhak125512033dh__ak
dread74419023_dread
dream85120393_dream
drear65016903_drear
dreck124812803_dreck
drek96321083_dre_k
eureka1034483eureka
freaks134713063_freaks
freaky16439233_freaky
gherao1036753gherao
great66034243_great
greek105915943_greek
head87137173_h_ead
heal75645693_h_eal
heap96432893_h_eap
hear76143883_h_ear
heat77061423_h_eat
heck135826493_h_eck
hereat93527413hereat
ihram10310183ihr_am
irreal657823irreal
leak86233713__leak
loreal63814313loreal
ochrea11316643ochrea_
ochreae12295083ochreae
ocrea73311823ocrea_
ocreae83310273ocreae
oread64619603_oread
paean77222723p_aean
palea75028663palea_
paleae84820293paleae
paleal84716673paleal
para65242173par_a_
parae76335703par_ae
paras76143043par_as
parbake1538353parbake
pardah123412823pardah
pare66760843pare__
pared86946763pare_d
parent83230423parent
pareo74632603pare_o
pareos87023773pareos
parer75839903pare_r
parers85530743parers
pares77164483pare_s
pareu74928743pare_u
pareus85420743pareus
pareve114613013pareve
pariah114320583pariah
parian83223963parian
park105237493par__k
parka115120883parka_
parkas125018023parkas
parlay113713993parlay
parral85517533parral
partake1339643partake
partan83820563partan
pea56657243p__ea_
peag75431343p__eag
peaks114825623p__eaks
peaky145718153p__eaky
peal68648103p__eal
pean66147173p__ean
pear69745233p__ear
peas65755063p__eas
peat65967933p__eat
peck125730683p__eck
peek106031433p__eek
pere66450263pere__
pereia85217983pereia
pereon83517453pereon
peres76246643pere_s
perk106232843p__erk
phaseal1245673phaseal
phat95837863ph__at
phew128417113ph_e_w
phial10313203ph_ial
phlegm1433093phlegm
phoebe1335003phoebe
phonal11310383phonal
phoresy1534653phoresy
phrasal1246163phrasal
phrase11109903phrase
phreakers1834673phreakers
phreaking1936463phreaking
phreatic1548343phreatic
phrenic1438773phrenic
phrensy1533623phrensy
phyla13469183phyla_
phylae14458733phylae
phylar14437373phylar
pilea75123953pilea_
pineal84817683pineal
plea66830603p_lea_
plead85818463p_lead
pleas75627033p_leas
pleat74734473p_leat
poleax1547993poleax
pore66451263pore__
pored85234513pore_d
pores75849033pore_s
pork106929683por__k
portal84218463portal
praam94815613p_raam
pram85733493p_r_am
prank115019453p_rank
prao66229023p_r_ao
prat65952043p_r_at
prau66529473p_r_au
pray96331533p_r_ay
preach133613923p_reach
preact103220393p_react
preamp1238993p_reamp
prearm104512343p_rearm
prebake1539093p_rebake
pree67044733p_re_e
preed85128113p_reed
preen75925053p_reen
prees75937173p_rees
prefab1336243p_refab
prelaw1139103p_relaw
preman104117453p_reman
preop94715873p_reop
prep86427673p_re_p
prepack1757643p_repack
prepay13310313p_repay
preps96220693p_reps
presa74319043p_resa
prese75228383p_rese
presoak1348453p_resoak
press75425953p_ress
prest75736353p_rest
pretax152310193p_retax
prewar114712573p_rewar
prex135722973p_re_x
prexy174611573p_rexy
prey96228483p_re_y
preys105717783p_reys
prez156126313p_re_z
prick134317503p_rick
prink114719673p_rink
proa66229963p_roa_
proas75028803p_roas
purda82914693purda_
purdah12288753purdah
purdas92612263purdas
pure65543333pure__
puree74632843pure_e
pureed95017803pureed
purees84721683purees
purely114013613purely
purer75127903pure_r
purest84021933purest
pyran10514473pyr_an
pyre94925553pyre__
pyrene113210733pyrene
pyres105523883pyre_s
pyrex175211213pyre_x
read55942533__read
real45750293__real
ream65841613__ream
reap65934743__reap
rear45644553__rear
reck106130563__reck
reek85232523__reek
reread71715433reread
rhea75017433rh_ea_
rheas84816953rh_eas
screaks13469353screaks
screaky16436213screaky
scream104814243scream
shea76031573sh_ea_
sheaf115424123sh_eaf
sheal84927703sh_eal
shear85424833sh_ear
sheas86331793sh_eas
sheik122514653sh_eik
shmear1176933shmear
shrank13359123shrank
shred98125613shre_d
shreds105613053shreds
shrew119720163shre_w
shrewd136810773shrewd
shrews129313913shrews
shriek134211103shriek
shrink134511733shrink
shrunk13357063shrunk
sneak96016173_sneak
speak114618673_speak
spheral1238423spheral
spirea84015633spirea_
spireas94412513spireas
spread9312533spread
squeak1935253squeak
steak95219803_steak
streaks114411273streaks
streaky14447813streaky
stream84717283stream
streek104111413streek
teak85930843__teak
thereat104315243thereat
thraw1110515923thr_aw
threads11419953threads
thready14435903thready
threaps12488643threaps
threats104311673threats
three87526913thre_e
threep115910113threep
threes97117323threes
thresh12276863thresh
threw1117315713thre_w
throat94819753throat
tread64821703_tread
treat56240353_treat
trek86222313_tre_k
troak95213573_troak
tweak1257753_tweak
unread73412673unread
unreal64414453unreal
upheap13105213uph_eap
uprear8168793uprear
urea46528053_urea_
ureal56722683_ureal
ureas55826013_ureas
weak117126303__weak
wheal115716183wh_eal
wheat114924573wh_eat
whelk154311063wh_elk
whereas13448903whereas
whereat134311923whereat
wreaks134711113_wreaks
wreck144611043_wreck

Search took 7 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 Filter1786911127160.1261418182.5
2DLD Change Limit1127162776.43617513.4
3Display Results2772770.0962885.4
 (SQL Overall)1786912776.65826838.5
 
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.