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

88 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
perimeter134956(None) 
perimeters1448601perimeters
aerometer11410202aerometer
decimeter14147412decimeter
parameter1349122parameter
pedometer1447732pedometer
perimetry1646502perimetry
peripter1278752peri_pter
permitter1345962permitter
pyrometer1648882pyrometer
trimeter10310082_trimeter
aerometers1249493aerometers
altimeter1146613altimeter
barometer13189043barometer
centimeter1445003centimeter
decameter14137363decameter
decimeters15156683decimeters
decimetre14125303decimetre
dekameter16135103dekameter
delimiter1246243delimiter
dimeter10411893__dimeter
dosimeter1245363dosimeter
durometer1246443durometer
ergometer1246153_ergometer
experimenter2373173experimenter
fermenter1497543fer_menter
ferreter1136543fer_reter
geometer1138423ge_ometer
heliometer1546303heliometer
hexameter2144853hexameter
hypermeter2055553hyper_meter
lysimeter1443553lysimeter
orometer10310703_orometer
oximeter1755153_oximeter
parameters1448133parameters
parietes10714553pari_etes
pedimented1644103pedimented
pedometers1547213pedometers
pentameter1445203pentameter
perfecter1646043perfecter
perigee101113393perige_e_
perigees1189503perige_es
perimetries1547783perimetries
periostea1144793periostea
peripeteia1453333peripeteia
peripetia1346663peripetia
peripeties1448403peripeties
peripety1546193peripet_y
peripters1368123peri_pters
permeate12311613per_meate_
permeated1439373per_meated
permeates13311773per_meates
permeator1347403per_meator
permitted1446653permitted
permittee1346683permittee
permitters1444623permitters
permute1138793per_mute_
permuted1336713per_muted
permutes1238713per_mutes
perplexer2042753perplexer
persister1146833persister
perter84422283per___ter
perverter1445563perverter
picometer1548913picometer
piezometer2343753piezometer
planimeter1443803planimeter
polarimeter15133203polarimeter
potometer1349843potometer
primate111516283p_rimate_
primates121515933p_rimates
primer105118683p_rim__er
primmer134310163p_rim_mer
printer93917303p_ri_nter
privater13158533p_rivater
promoter12311453p_romoter
prompter1437983p_rompter
pyrometers1748333pyrometers
rimester1037813__rimester
riveter10208753__riveter
salimeter1157373salimeter
spherometer1854153spherometer
spirometer1445763spirometer
taximeter1844413taximeter
telemeter1147283telemeter
tetrameter1255203tetrameter
trimester1145823_trimester
trimeters1139213_trimeters
variometer1545683variometer

Search took 8 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 Filter1786911486410.436409841.7
2DLD Change Limit148641887.09620947.2
3Display Results88880.0461913.0
 (SQL Overall)178691887.57823580.2
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.