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

You can choose a higher Change Limit to return more words, although it will take longer.
to automatically increase the Change Limit after seconds.

77 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
ornerier84604(None) 
onerier7311611o_nerier
orderer8127942order_er
orneriest947402orneriest
orreries8310122orreries
aerier64823153__aerier
angrier839023_angrier
arteries8321483arteries
beerier93613023_beerier
borderer1168103border_er
breezier1934533breezier
brevier1237763br_evier
cheerier1348003cheerier
cornered11311133corner_ed
cornering12311893cornering
cornermen1345733cornermen
cornier93017093corn__ier
creepier1236253creepier
crepier1139743cr_epier
drearier9297923drearier
eerier64320023__eerier
ferneries1239043ferneries
fierier103511193_fierier
fineries112416743fineries
forgeries13310003forgeries
greedier1036083greedier
greenier938713greenier
hornier103012463horn__ier
hungrier1233893hungrier
joineries1648103joineries
leerier73111503_leerier
lonelier838003lonelier
nerdier83110353__nerdier
nervier10298833__nervier
observer1344733observer
offerer1335543offer_er
oneriest8313443o_neriest
orangerie10105483orangerie_
orangeries11116943orangeries
orangier947713orangier
orbier839993or__bier
ordered9108533order_ed
orderers9116563order_ers
ordering1039353ordering
orderlies1045453orderlies
ordinarier1153123ordinarier
orienter838313orienter
orneriness1045443orneriness
ornery938463orner__y
pineries102419083pineries
pornier93413133porn__ier
premier113515633pr_emier
querier16310013_querier
reedier83815303_reedier
reefier102912553_reefier
reekier113111123_reekier
relier65826183_r_elier
rentier73618223_rentier
roperies10315763roperies
roseries8317313roseries
roturier836033roturier
sneerier878103sneerier
sorcerer1036433sorcer_er
sorceries1149933sorceries
sorrier72313733sor__rier
spherier1337783spherier
towerier1137123towerier
trendier937913trendier
turneries948493turneries
veneries112815033veneries
verier94620963__verier
vineries112716043vineries
waterier11312083waterier
wineries112316533wineries
winterier1238333winterier
wintrier1136873wintrier
worrier102311683wor__rier

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.420425454.8
2DLD Change Limit146162777.90618487.5
3Display Results77770.0332333.3
 (SQL Overall)178691778.35921377.1
 
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.