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 “scarier” with Change Limit: [1] [2]

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

107 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
scarier9401787(None) 
scalier94316911scalier
scarcer113911371scarcer
scarer84524611scar_er
scarfer124511081scarfer
scarper114814821scarper
scarrier10298451scarrier
cagier93715932_cagier
cahier113615772_cahier
cakier123115242_cakier
carder94524182_carder
career85822242_career
carer74942332_car_er
caried94528692_caried
caries85147622_caries
carper104923632_carper
carrier93619582_carrier
carter84932272_carter
carver114420152_carver
charier124317902charier
crier74724462_c_rier
glarier84112212glarier
hoarier104211742hoarier
learier73415662learier
sagier73717162s_agier
sarkier113413312s_arkier
scabbier1435132scabbier
scabies11613332scabies
scaler84321602sca_ler
scalper113912922scalper
scammer133611972scammer
scamper134613162scamper
scanner94411812scanner
scanter94215182scanter
scantier10309982scantier
scarce104013632scarce_
scare75334462scar_e_
scared95227292scar_ed
scareder1135792scareder
scarers94618512scar_ers
scares85033002scar_es
scarey115016982scar_ey
scarfed134711182scarfed
scarfers13408462scarfers
scariest101615952scariest
scarifier1446652scarifier
scarify1537442scarify
scarily12311702scarily
scaring103421972scaring
scarlet91516942scarlet
scarped124314402scarped
scarpers124712512scarpers
scarred104512632scarred
scarted104816122scarted
scarves124511622scarves
scatter93815172scatter
scattier10267582scattier
scauper11379452scauper
scorer84818262scor_er
scorner9259762scorner
scraper114513422scraper
scriber113910972sc_riber
scried95817302sc_ried
scries85226822sc_ries
scurfier13267052scurfier
scurvier13255882scurvier
seamier93114632seamier
searer65432022sear_er
shadier113111152shadier
shakier143411152shakier
shalier103116422shalier
sharer95025482shar_er
sharker144313812sharker
sharper124312702sharper
slatier74016812slatier
smarmier1235032smarmier
smarter94113132smarter
smearier1036952smearier
snakier112810002snakier
snarer64620842snar_er
snarkier12336512snarkier
snarler73610632snarler
snarlier8278182snarlier
soapier93411712soapier
soarer64522242soar_er
sorrier72313732sorrier
spacier114011632spacier
sparer84524962spar_er
sparger103613082sparger
sparker133914362sparker
sparkier14298032sparkier
sparrier10329142sparrier
sparser94311482sparser
spirier93214072spirier
sprier84119062s_prier
stagier83513442stagier
starer64027362star_er
starker114114692starker
starrier8279462starrier
starter73817882starter
starver104611992starver
sugarier937392sugarier
swarmer1247802swarmer
tearier73815612tearier
varier94619352_varier
warier93722892_warier
wearier103613282wearier

Search took 4 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 Filter1786911076710.376475242.0
2DLD Change Limit1076711073.43631336.1
3Display Results1071070.0333242.4
 (SQL Overall)1786911073.84546473.6
 
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.